Specific Countif formula (matching cell then counting all occurrences in column)

[willow1985]

Hello,

I am looking for a specific countif formula. Basically in column E I have names of locations:

E

Blue
Red
Blue
Green

In Cell H10 I have the word "Blue"
In Cell H9 I want a formula to look in Column E, find how many match Cell H10 and return the number, in the above case: 2

I thought it would be something like: COUNTIF(E:E,H10,E:E) but I know this is not right and I am missing something. I also thought maybe:
COUNT(IF(E:E=H10),E:E)) but I know this is incorrect as well. I am drawing a blank at the moment and hope someone can help me.

Thank you

Carla

 

[kweaver]

This is roughly the same as your other post.

 

[Fluff]

Try
=countif(E:E,H10)

 

[willow1985]

I now see how it can be related. Is there a way to not count blank cells?

 

[willow1985]

I have this formula but it gives the result of "0" instead of a blank if the reference cell (H10) is blank.

=COUNTIFS(E:E,H10,E:E,"<>")

 

[kweaver]

One way: =IF(ISBLANK(H10),"",COUNTIF(E:E,H10))

 

[kweaver]

I have this formula but it gives the result of "0" instead of a blank if the reference cell (H10) is blank.

=COUNTIFS(E:E,H10,E:E,"<>")

That's because it's COUNTING...so, there are 0.

 

[Fluff]

If H10 has a formula that sometimes returns "", use
=If(H10="","",countif(E:E,H10))

 

[willow1985]

Thank you very much

 

[Fluff]

Glad we could help & thanks for the feedback