Formula help

[hopeace]

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

[Domenic]

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 <[email protected]>,
hopeace <[email protected]> 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......Sue
> ..............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

[hopeace]

Thank you Domenic! I would never have been able to figure that out, and it worked!

I wish for you a good day full of sunshine and fortune.

These stats are ultimately help me do a better job at supporting the youth in the school I work at (im a youth and family counsellor).

Thanks for your help.

keith