if, if(and), sumif or sumproduct

[pippip]

I'm trying to do a formula that does the following:

if A:A = "temp" and B:B = "a" then return 0, but if A:A = "temp" and B:B <> "a" then add C:C (but only those cells in C:C where A:A = "temp" and B:B <> "a").

So, in column A I have various categories (including "temp") and in column B those categories will either have an "a" against them or will be blank. In column C are the figures. In another cell I want to put the formula that will either return 0 (because every "temp" is matched by an "a") or will return the sum of those figures where "temp" is not matched by an "a").

I hope that all makes sense. I've searched around and tried different ways of doing this, but without luck. The stumbling block seems to be adding column C:C only where the two conditions are met.

Thanks in advance for your help.

 

[T. Valko]

Just tried it again and it worked. Perhaps I entered something incorrectly in my earlier attempts.

Thanks again.

Good deal. Thanks for the feedback!

 

[T. Valko]

I thought it was strange it didn't accept the 'not equal to' syntax and preferred the 'less than' syntax. I'm happy with dumb luck when it works.

And now I have two solutions and my understanding of excel continues to grow.

Dumb luck is better than the type of luck I have (no luck).