SUMIFS

Hi,
I'm looking to sum the cells in a column if another corresponding column is either of two values. I'm getting #UNPARSEABLE though! 😕
=SUMIFS({Data Range Spend}, {Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”))
Any thoughts welcome!
Thanks,
Derek
Best Answer
-
Hi @Del Horne ,
This looks like you'll just need a SUMIF. Here's what you'll use:
=SUMIFS({Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”),{Data Range Spend})
Note that I moved the range you want to sum to the end, because (for some strange reason) the summed data is at the end in a SUMIF instead of the beginning, as in SUMIFS.
Hope this helps!
Best,
Heather
Answers
-
Hi @Del Horne ,
This looks like you'll just need a SUMIF. Here's what you'll use:
=SUMIFS({Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”),{Data Range Spend})
Note that I moved the range you want to sum to the end, because (for some strange reason) the summed data is at the end in a SUMIF instead of the beginning, as in SUMIFS.
Hope this helps!
Best,
Heather
-
Thanks @Heather D – also turns out the issue was I had pasted in the formula from TextEdit and the smart quotes came over too. Must remember to convert to plain text! 🤣
-
Hello. Hope everyone is well. I'm having issues with a =SUMIF OR =SUMIFS formula
=SUMIFS({Fed Admin FTE Usage}, >0, {Employment Status}, "On-Board")
I'm getting invalid operation. Please help.
-
Hi @MoJones ,
You are missing one component - the range you want to sum.
=SUMIFS({name of range you want to sum}, {Fed Admin FTE Usage}, >0, {Employment Status}, "On-Board")
That should do the trick - just replace the bolded part with the actual name of the range. If you're wanting the FTE Usage range, you can put that in there.
Hope this helps - let me know if it works!
Best,
Heather
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!