SUMIFS criteria

Colin Janssen
Colin Janssen ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi All,

I'm trying to do a SUMIFS, and whilst I can return a result individually using SUMIF, when I try and combine I get #INVALID OPERATION.

The formula I am trying to use is

=SUMIFS({SERVICE DETAIL}, LEFT(@cell, 3) = "Col", {FEB 18}, {SERVICE TYPE}, "Transition", {FEB 18})

RESULT = #INVALID OPERATION

If I separate it out as below I get  a result

=SUMIF({SERVICE DETAIL}, LEFT(@cell, 3) = "Col", {FEB 18})

RESULT = $12,858.53

=SUMIF({SERVICE TYPE}, "Transition", {FEB 18})

RESULT = $45,856.12

I'm surely doing something stupid. Any help would be appreciated.

 

Regards

 

Colin

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!