Formula to add two columns together that meet the same criteria
Hello,
Need some help with a formula, I am trying to add two columns that meet the same criteria from one sheet to total on another sheet.
I have tried Sumif and sumifs formulas but they both comeback with errors
Here is what I need:
On sheet 1 I want to total columnA and columnB on sheet two if they meet (this) criteria.
I have tried this:
=SUMIFS({Jobs Data Report as of 4.12.19 Range 2}, [Job Number]4, {Jobs Data Report as of 4.12.19 Range 4}, [Job Number]4, {Jobs Data Report as of 4.12.19 Range 5})
but it comes back #INCORRECT ARGUMENT.
I need it to add {Jobs Data Report as of 4.12.19 Range 4} and {Jobs Data Report as of 4.12.19 Range 5} if it matches [Job Number]4 into one cell in a different sheet.
Comments
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!