# Formula for sum all

✭✭

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).

• ✭✭

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:

• ✭✭✭✭✭✭

@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")

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!