ariel20029
Board Regular
- Joined
- Jun 20, 2013
- Messages
- 97
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)
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)