Sumif formula with multiple criteria
Options
I’m trying to write a formula for a dashboard rollup sheet and am having some difficulty.
This is what I have written but it comes back incorrect argument.
=SUMIF({2021 FLS Small Project Tracker Range 1}, "Reserve Fund", {2021 FLS Small Project Tracker Range 3}, "Apparel", {2021 FLS Small Project Tracker Range 7})
I want the formula to sum the dollars in Range 7 if it is an Apparel department that is funded with Reserve Fund.
Tags:
Best Answer

I figured it out. No need for help.
Answers

I figured it out. No need for help.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!