Countif

Max · Apr 23rd, 2002, 10:30 AM

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. · Apr 23rd, 2002, 10:34 AM

{=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 · Apr 23rd, 2002, 10:34 AM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 10:30 AM	#1
Max New Member Join Date: Apr 2002 Location: Pittsburgh Posts: 1	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!

Apr 23rd, 2002, 10:34 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	{=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".