Array formula not counting correctly

[ariel20029]

Hi all,
I copied an array formula for median and changed it to count. For some reason the count is off by one. I double checked the range. I manually checked the count and there are only 2 distributors in the population but the formula is showing 3. And the End Customer/Partner is short by 1.

Please help.
Sharon

=COUNT(IF(($A25:$A223="End Customer")+($A25:$A223="Partner"),$G25:$G223))


=COUNT(IF(($A25:$A223="Distributor"),$G25:$G223),0)

 

[njimack]

=SUMPRODUCT(--(ISNUMBER(MATCH($A25:$A223,{"End Customer","Partner"},0))))
=COUNTIF($A25:$A223,"Distributor")

 

[ariel20029]

Thank you so much- I will give it a shot!!!

 

[ariel20029]

Hi- I need it to count column G not column A - A has the description, but G has the field I need to count as some are blank in column G). thanks,
Sharon

 

[njimack]

It's helpful if you provide a small sample of your data with desired results...

=SUMPRODUCT(--(ISNUMBER(MATCH($A25:$A223,{"End Customer","Partner"},0))),--($G25:$G223<>""))

 =SUMPRODUCT(--($A25:$A223="Distributor"),--($G25:$G223<>""))