I need help with a if formula to get the $ amount total if another column = a specific item.

Elayne Smith

I want to make a formula in the Column "A Total" in the highlighted Cell, that will give me the Sum of $ from Grand Total Column if the A is in the Project column.

Nick Korna

Hi @Elayne Smith,

The formula for this would be:

=SUMIF(Project:Project, "A", [Grand Total]:[Grand Total])

Hope this helps - any issues etc. then just post! 😊

Nick Korna

Hi @Elayne Smith,

The formula for this would be:

=SUMIF(Project:Project, "A", [Grand Total]:[Grand Total])

Hope this helps - any issues etc. then just post! 😊

Paul Newcome

Give this a try:

=SUMIFS([Grand Total]:[Grand Total], Project:Project, @cell = "A")

Elayne Smith

Thank you both.

Paul Newcome

Happy to help. 👍️