How do I count cells with specific value?
Hello every one,
I am still trying to wrap my mind around array formula, this is my challenge
now.
How do I count cells with specific value?
Example:
___A____B__C__D__E__F__E
1_ONE___X_____Y_____Z___
2_TWO_____Y______Z__Z__
3_TWO___Z_____Y____X__Z
4_ONE___Y__Y_______Z___X
5_TWO_________X_______X
6_TWO_____X______Y____Y
7_ONE___X______________X
8_ONE_____X____Z__X____Y
In a column A1:A8 I got some ONEs and TWOs, how do I count, how many Y
there are in ONE rows, range B1:E8. The way I see it, it is calling for array
formula.
Please help!
Thank you,
Guntars
|