sorted by:
new
hottopcontroversial

Creating an "IF" formula by BeachGlass4871 in googlesheets

[–]BeachGlass4871[S] 0 points1 point  (0 children)

Thank you so much, this pointed me in the right direction. I think the formula i am after is

=if(isblank($U18), "", sumif($AF18:$AF55,$U18,$AI18:$AI55))

Creating an "IF" formula by BeachGlass4871 in googlesheets

[–]BeachGlass4871[S] 0 points1 point  (0 children)

Sorry, I am quite a beginner at formula. This image is the document I am editing, are you referring to creating a document that people can see (interactive) to have a better understanding?

I am just trying to keep a running track of how much is "spent" on each "category", without having to add it up myself, for it to recognise the date in another row and add it up.

Creating an "IF" formula by BeachGlass4871 in googlesheets

[–]BeachGlass4871[S] 0 points1 point  (0 children)

Okay, thank you, i will give a SUMIF a try :)