Assuming that A1:E5 contains your data, try...

A3, copied down:

=SUMPRODUCT(--($C$2:$E$2="Y"),--(C3:E3="X"))

Hope this helps!

In article ,
hopeace wrote:

Hi! I really need help to arrange this formula!! I work with students in
a school and need to count a certain value if a different cell has a
certain value.

Each student has their own column. One row for each column is entitled:
"Active client". I will answer "y" if that student is currently working
with me, and "n" if not. Then each row will either have a "x" or be
blank.

I want to calculate the total "x"s for all the students in each row,
only if their "Active status" is "y".

Total.......Name...........John.......Mary......Su e
..............Active.............Y............Y... .....N
.2...........In School........X............X.........X
.0...........Red hair..................................X
.1...........Happy.............X.................. ...X



Please can anyone help me?
Many, Many thanks!

keith