SUMIFS Formula Help

I'm trying to sum total JAN COST from another sheet if it meets 2 criteria. 1st is that it matches the PF LBC, second is that it matches the 5 CC Code. Sum the total when both criteria match. I've tried a number of formulas and get UNPARSEABLE or INCORRECT ARGUMENT errors.

=SUMIFS({JAN Cost}, {PF LBC}, [PF LBC]@row, {5 CC Code}, [5 CC Code]@row)

All are Text/Number and column headers from both sheets (primary/data) match.

TYIA!

Find more posts tagged with

Accepted answers

All comments

HnDrX

NickStaffordPM

Hey! So I believe the issue if you have the criteria in the formula just pulling from the value that is in that row for that column. You need to fix the selection critera on one cell in particular or include the text you want within " " like the following - "example answer ABC"

the column@row is the issue I am referring too.

Let me know if this helps!

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.