help needed to count instances?

[Gerry]

Does anyone know how to count 'instances' across a row.
ie.
in a1 to c1 might contain H.
d1 to f1 might contain b
g1 to i1 might contain H.
I need to calculate the number of times h appears (=2)

 

[Frank Kabel]

Hi
try
=COUNTIF(A1:I1,"H")

 

[David M]

I would create a pivot table,then format the field setting
to count the data in that row, then only show (H)....

Regards

 

[Guest]

using countif sums the total count of H,,,,I was hoping
that it would only count the appearances? ie in my example
2

 

[Guest]

as it is part of a suite of analysis ...not a option

 

[Frank abel]

Hi
o.k. try
=SUMPRODUCT(--(A1:I1="H"),--(B1:J1<>"H"))

Note the different starting points for both ranges

 

[Guest]

THANKS...it seems to work...what does the (--( do?

-----Original Message-----
Hi
o.k. try
=SUMPRODUCT(--(A1:I1="H"),--(B1:J1<>"H"))

Note the different starting points for both ranges

.

 

[Frank Kabel]

Hi
the double minus / unary coerces a boolean value to a number
(TRUE=1,FALSE=0)