Sum Ifs Formula

Nathan Umbriac

Hello,

I was able to create a formula to reference a sheet and calculate total activity cost per month:

=SUMIFS({May}, {Activities}, CONTAINS("Book-in", @cell))

Results are the total cost of activities that contain 'Book-in'.

However, when I tried to recreate this formula and reference another sheet, I get incorrect argument set:

=SUMIFS({January 2019}, {Activities}, CONTAINS("book", @cell))

Any thoughts?

Thank you!

Nathan

Find more posts tagged with

Accepted answers

All comments

Hannah H

Hi @Nathan Umbriac,

I tried your formula and it worked for me. Have you tried writing the formula from scratch? It could be the sheet references have got their wires crossed.

Best,

Hannah

Nathan Umbriac

@Hannah H Thank you. I deleted the formula and retyped it. My assumption as well is that the references needed to be re-referenced.

Thanks for your help!

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.