How do you get excel to count only if two logical statements are fulfilled, using ranges ?

[led84]

Dear All,

This is my first mr. excel forum post so please go easy on me! I've done a search and can't find the answer to this question elsewhere on the forum

I am trying to get excel to count a value if (and only if) two logical conditions are fulfilled on two different cell ranges.

1st condition: In cell range x, the value should = C2

2nd condition: In cell range y, the value should be greater than 0

I've tried an AND statement and failed, and I've also tried COUNTIF statemetns and had no more luck. This could well be due to my skill level however.

Any advice would be much appreciated!

Thanks.

 

[Redwolfx]

=Countif(RangeX,C2)+Countif(RangeY,">0")

 

[led84]

Thank you Redwolfx - the only problem I'm having is that that formula seems to sum the totatls of the two count if statements (it's returning a value that's too high) I'm looking the cell to only be counted if both of the statements are true.

e.g. if the value of the cell in range X does = C2 AND the value of the cell on the same row in Range Y is >0 then count it as one value. Does that make sense?

 

[Robert Mika]

Thank you Redwolfx - the only problem I'm having is that that formula seems to sum the totatls of the two count if statements (it's returning a value that's too high) I'm looking the cell to only be counted if both of the statements are true.

e.g. if the value of the cell in range X does = C2 AND the value of the cell on the same row in Range Y is >0 then count it as one value. Does that make sense?

Excel 2003
=SUMPRODUCT(--(rangex=C2),--(rangey>0))
For Excel >03 use COUNTIFS

 

[led84]

That's done it! Thank you very much.