Sumif formula help
Hello,
I may be on the rite track with sumifs but have not had luck in cracking it.
I am looking to sum 3 things. The total of the value associated to a months forecast. the total marked as complete in that same month in a different column and then the difference between those.
I have 3 columns to reference date for forecast, date for completion and a number column showing the value.
Sample of the format I am referencing is below. I would like to be able to create this for each month in a calendar year to produce these 3 metrics across the year. Any help is very much appreciated! I am consistently getting incorrect arguments and may not be on the rite path.
Best Answer
-
That worked perfectly thank you very much Paul!
Answers
-
Try something along the lines of...
=SUMIFS(Value:Value, Complete:Complete, ISDATE(@cell))
=SUMIFS(Value:Value, Forecast:Forecast, AND(IFERROR(MONTH(@cell, 0) = 4, IFERROR(YEAR(@cell), 0) = 2020))
-
That worked perfectly thank you very much Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!