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.
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.