SUMIF Formula with Checkbox Criteria

Hello,

I used to be able to use a sumif formula and pull in lines values that had a check box in one reference column or not checked in another reference column, and now that formula I used in the past doesn't work, I would use ...,{column Reference}, TRUE... ...,{column Reference}, FALSE...

I can get around the issue with helper columns but I don't really want to resort to that solution, any ideas as to how I can rework my formula to correct the error?

Find more posts tagged with

Sheets

Finance

Formulas

Solution Center

Accepted answers

All comments

Michael Culley

Can you paste the exact formula you used so we can see where the error may be occuring?

JMSLEE_VCEA

=SUMIFS({FY2022 Transaction Sheet Range 6}, {FY2022 Transaction Sheet Range 3}, Program@row, {FY2022 Transaction Sheet Range 4}, false, {FY2022 Transaction Sheet Range 5}, true, {FY2022 Transaction Sheet Range 7}, "6000:Goods and Services")

This is the formula in my prior data set that works and it won't work in my new sheet.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.