SUMIFS based on date criteria
I am trying to add the sums of 3 different columns, with the criteria that the date of the rows being summed is created is greater than a certain day.
The formula below has worked for summing just one column based on "Created Date" being greater than 11/10/2021, but when trying to add three columns I'm getting an #INVALID OPERATION error. What am I missing??
=SUMIFS([Column1]:[Column1], [Column2]:[Column2], [Column3]:[Column3], [Created Date]:[Created Date], >DATE(2021, 11, 10))
Thank you!
Best Answer
-
SUMIFS only sums one range. The other ranges are for different evaluation criteria.
You could try:
=SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column1]:[Column1]) + SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column2]:[Column2]) + SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column3]:[Column3])
A bit brute-force, but it should work.
dm
Answers
-
SUMIFS only sums one range. The other ranges are for different evaluation criteria.
You could try:
=SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column1]:[Column1]) + SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column2]:[Column2]) + SUMIF([Created Date]:[Created Date], >DATE(2021, 11, 10), [Column3]:[Column3])
A bit brute-force, but it should work.
dm
-
@Dale Murphy Thank you so much! This worked perfectly. I didn't know that about SUMIFS - makes sense.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!