willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 929
- Office Version
- 365
- Platform
- Windows
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
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