Totaling cost by month
I am tracking medical case cost, i am trying to auto calculate the cost for the month using a date range. Formula is giving incorrect argument error.
=SUMIFS({date}, AND(@cell <= DATE(2019, 5, 1), @cell >= DATE(2019, 5, 31), {cost}))
someone help tell me where i am going wrong?
Answers
-
=SUMIFS({cost}, {date}, <=DATE(2019, 5, 1), {date}, >=DATE(2019, 5, 31))
I got this to equal 0, which is not right, but had found another formula to try
-
Hi @Kyle Black
You found the issue I was going to point out - with a SUMIFS (plural), you put the range you want to SUM at the start of the formula, versus the end.
A 0 would indicate that the formula is structured correctly, but it either can't find data for that date range or that your {cost} column is being read as text instead of values to SUM. If you're still seeing incorrect results, could you post a screen capture of the referenced sheet (but please block out sensitive data!)
Thanks,
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!