Invalid Data Type Error for Embedded AND statement within an SUMIF

I'm trying to sum project estimates based on department and type of project. Basically if the department is "Operations" and the type of project is "MC" then sum the estimates for those conditions? Also referencing another sheet.

I receive an "Invalid Data Type" using the formula below.

=SUMIF(AND({5 Year Capital Plan (LC MC & DC) Range 3}, ="MC", {5 Year Capital Plan (LC MC & DC) Range 1}), ="Operations", {5 Year Capital Plan (LC MC & DC) Range 2})

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!