# Date Formula

edited 12/09/19

I looking for help on a formula that will SUM the column by month. So when I go into a new month, it will sum only the month we are in since the column represents all months of the year. I have a supporting value and formula sheet that host these values and are linked to my dashboard. I currently have to edit reference the fields to select the cells in the present month. I have attached an image of the columns in question. Any help in this matter will greatly be appreciated.

Tags:

## Comments

• ✭✭✭✭✭✭

Hi there,

You can accomplish this using a SUMIFS statement. Try this formula

=SUMIFS(Fee:Fee, [Date Approved]:[Date Approved], MONTH(@cell) = MONTH(TODAY()), [Date Approved]:[Date Approved], YEAR(@cell) = YEAR(TODAY()))

It will look at the month and year of today and provide you with the sum value of all of the fees of the current month/day.

If you want to manually input the year and Month you can use this one... This would be good for summary data for each month.

=SUMIFS(Fee:Fee, [Date Approved]:[Date Approved], MONTH(@cell) = 3, [Date Approved]:[Date Approved], YEAR(@cell) = 2018)

Replace the 3 with the month you want and the year with the year you want.

Hope that helps!

https://help.smartsheet.com/function/sumifs

• Thank you  Mike, the formula worked perfect for my situation.

• ✭✭✭✭✭✭

Awesome. Glad I could be of help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!