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!
Answers
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!