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?

Find more posts tagged with

Accepted answers

All comments

Kyle Black

=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

Genevieve P.

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.