| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Text In Column
I just need a formula to count how many times "ZB" appears in column H.
I've tried =SUMPRODUCT(H1:H300="zb") =COUNT("zb", H2:H300) =COUNT(H2:H300, "zb") This does not seem like a terribly difficult formula, but everything returns 0. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Text In Column
Try the following formula, substituting your range for the range A1:A16:
=COUNTIF(A1:A16,"=ZB") -- Kevin Backmann "Jeremy" wrote: I just need a formula to count how many times "ZB" appears in column H. I've tried =SUMPRODUCT(H1:H300="zb") =COUNT("zb", H2:H300) =COUNT(H2:H300, "zb") This does not seem like a terribly difficult formula, but everything returns 0. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Text In Column
Try like this:
=COUNTIF(H2:H300,"zb") or =SUMPRODUCT(--(H2:H300="zb")) "Jeremy" wrote: I just need a formula to count how many times "ZB" appears in column H. I've tried =SUMPRODUCT(H1:H300="zb") =COUNT("zb", H2:H300) =COUNT(H2:H300, "zb") This does not seem like a terribly difficult formula, but everything returns 0. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup text in one column, count in another column | Excel Worksheet Functions | |||
| count text occurences in a column | Excel Discussion (Misc queries) | |||
| Count Text in Column? | Excel Discussion (Misc queries) | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Hybrid Mode
