Countif with row criterion

[stakar]

Hi!
I have 200 columns. I want to countif() all the 200 columns to coun
the 0, 1, 2, 3 for each row of them , but also i want to set 1 mor
criterion.

In the row 3 on each column (A3, B3, C3, .... IV3) there a number 1,
... 50 that it uses to group all the 200 columns.
So, i get 10 columns with the 1 (group 1),
5 columns with the 2 (group 2)
15 columns with the 3 (group 3) and so on.

I want to use the countif() using this criterion also.

thanks in advance
Stathi

 

[Frank Kabel]

Hi
if your values to count are in row 2 try:
=SUMPRODUCT(--(2:2=1),--(3:3=1))

 

[stakar]

Thanks a loT
That was all i wante