Sumif formula with multiple criteria
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!