Countif

[Max]

I am trying to count the number of values in one column based on a second criteria in a second column. In this case I want to count all "A"s in column B for which there is an "x" in column D.
Any help would be very appreciated.
Thanks!

 

[Mark W.]

{=SUM((B1:B10="A")*(D1:D10="X"))}

Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. For more on array formulas see the Excel Help Index topic of "About array formulas and how to enter them".

 

[Aladin Akyurek]

On 2002-04-23 09:30, Max wrote:
I am trying to count the number of values in one column based on a second criteria in a second column. In this case I want to count all "A"s in column B for which there is an "x" in column D.
Any help would be very appreciated.
Thanks!

=SUMPRODUCT((B2:B100="A")*(D2:D100="x"))

You can also use cell refs instead of "A" and "x" if you have them in cells of their own.