SUMIF condition

Fede ✭✭
edited 12/09/19 in Formulas and Functions

Hi guys!


I have to calculate average in my sheet and I will use: SUMIF / COUNTIF

- COUNTIF formula is working. 

- SUMIF formula is not working, i am getting #INVALID OPERATION

The SUMIF formula is (screenshot attached) =SUMIF([Assigned to in Region]8:[Assigned to in Region]136, "Sarah Mabiletsa", [Quote Prep Cycle time]8:[Quote Prep Cycle time]136)


The Assigned to is a contact list column

The Quote Prep is a text/number column (the numbers are coming from a formula)

Can someone help out?

Thanks in advance!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!