How do you count a value once per row?

[JonnyEnglish]

I’d like to know how to create a formula that will tell me the total number of rows that have a specific value

Using the table below as an example I’d like the formula to tell me that A is in 3 of the 4 rows but I don’t know where to start.

Any help would be appreciated

A	A	A
A	B	B
B	B	B
A	A	A

[jeffreybrown]

How about using a helper column...

Please Login or Register  to view this content.

D1: =COUNTIF(A1:C1,"A") >> Copied down
E1: =COUNTIF(D1:D4,">0")