Date Formula

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.

Find more posts tagged with

Formulas

Comments

Mike Wilday

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

americansurveymanagement35236

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

Mike Wilday

Awesome. Glad I could be of help!

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…