Having problem with inserting inequality in SUMIF

**Haleh** · 01-26-2014, 08:00 AM

I have this SUMIF function with the criteria defined as Crt.

Please Login or Register  to view this content.

It works when Crt is a value(eg. Crt="1.5"), but when I try to change it to inequality (eg. Crt= ">=1.5"), Run time error '1004' occurs.

I'd appreciate any help!

**Richard Buttrey** · 01-26-2014, 08:23 AM

Maybe

Please Login or Register  to view this content.

**Haleh** · 01-26-2014, 08:46 AM

I'm so grateful for your help!

It's working... I think I get it now! It's because SUMIF formula works when you insert a number without any quotation mark! But when it comes to inequality it has to be in quotation!

again, thank you!