I want to be able to create a cell that can add numbers that are found below a specific text.
In the image below there is an image with the basic draft for the idea, however the idea is not to add manually selected cells, as if I add a lot of new cells I would have to manually add them to the addition (=H12 H14 H16)
.
By making it so it adds all the things below a specific line of text, even when I add more of this cells, the addition will be made automatically without the need of adding the cells individually to the addition.
Of course if this type of 'cell detection' is possible this could make for a lot of more complex equations that usually need manual input to be done automatically as soon as it is added.
I imagine the code looking something like this:SUMiIF cell untop = "sales"
CodePudding user response:
Try the following
=SUMIF(A2:A,"="&"sales", OFFSET(A2:A,1,0))