IF Function and Countif Function in One Cell???

[kezia.wrench]

Hi

I'm trying to work out a formula that will calculate the following:

If cell in column A = Open, I want to calculate the sum of the numbers in the cells in column C, where the cells in column B state OPS. If it doesn't I want the calculate to result in 0.

Please help.

Regards
Kezia

[DonkeyOte]

Assuming XL2010 (or XL2007) see: SUMIFS function in XL Help

=SUMIFS(C:C,A:A,"Open",B:B,"OPS")