CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Gabriel Vallejo
Gabriel Vallejo

Reputation: 21

How to sum all the numbers under the same name? (Google Sheets)

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"

enter image description here

Upvotes: 1

Views: 893

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

Try the following

=SUMIF(A2:A,"="&"sales", OFFSET(A2:A,1,0))

enter image description here

Upvotes: 1

Related Questions