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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!