Count if not equal to ??

[Hoopsah]

Hi,

Is there a possible formula for this?

I have been going throug SUMIF's and SUMPRODUCTS but both seem to be for a positive criteria.

I am trying to get a formula that would basically be:

If Column C is not equal to "Complete" then Add columd D = AB + Column E =CD

Thanks

 

[RoryA]

Do you mean this?

=COUNTIFS(C:C,"<>Complete",D:D,"AB",E:E,"CD")

 

[Hoopsah]

You are a star Rory - Exactly what I needed.

Thank You