counting cells

H

herman

There must be a easier way
I'm trying to find a simpliar way of counting a large
range of cells H1 to HA1 that have different alpha numeric
entries in each cell ie gr1,gr2,hr1,hb1,gb2,gn1,pb1,pn2 etc
I need to count all the cells with gxx or pxx or hxx is
there something easier then
b2=countif(H1:HA1,"gr1")+countif(H1:HA1,"gr2")etc,etc for
all mine gxx entries te same would also apply for all my
Hxx and Pxx entries within the same range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count if equal to not working? 1
Count Number of occurences of several texts in a range of cells 3
Excel 2003 Counting multiple number entries in a single cell 7
Count with merged cells 2
Count cells in column that contain number in a range 9
count the dates for each criteria and list total occurances for ea 1
COUNTIF, only counting once if both cells contain the data 5
SUMPRODUCT formula compare then count 3

Top