Formula for sum all

GabyC

Hello,

I need a formula that will SUM ALL in these 2 columns if the month is January. So in the example below the total in all the rows should be $2,009 (red column).

Bobby S.

You can use formatting very similar to Excel:

=SUM([Jan 23 Estimate]@row,[Jan 23 Spent to Date]@row)

That should give you the desired result by cell.

You can also just dig through their mathematical functions in the drop down here:

Jeff Reisman

@GabyC If you're looking for the sum total of all cells in those two column where the Month = January, you can use the SUMIFS function.

=SUMIFS([Jan 23 Estimate]:[Jan 23 Estimate], Month:Month, "January") + SUMIFS([Jan 23 Spent to Date]:[Jan 23 Spent to Date], Month:Month, "January")