Sumproduct... or Countif

I have a spreadsheet that I manage inmates with.
I have one column (H) that ranks them in order of "needs assessment". They
can be either H, M, or L (High, Medium or Low).
Columns M through Q are the Basic programs they take. If they are on the
course they get an X in that column.

If they have only applied for the course but have not taken it, then they
are an A (applied) for the column.

What I want to do is report how many inmates who are rated Low (or any other
rating) are taking courses in that array of columns (M, N, O, P and Q).

I tried countif... but it counted the number of inmates marked L and added
it to the number of X's in the columns M-Q.

Can anyone help with this? I could not get sumproduct to work at all.

Thanks for your patience...
Nick.

Lets say that you enter the "needs assessment" you're looking up in R1 (H,
M, L),
And the course taken "X" or the course applied for "A" in S1.

Then try this formula:

=SUMPRODUCT((H2:H100=R1)*(M2:Q100=S1))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Barney Quinn" <morpheseus@hotmail.com> wrote in message
news:VCK1e.820355$8l.53888@pd7tw1no...
> I have a spreadsheet that I manage inmates with.
> I have one column (H) that ranks them in order of "needs assessment".
They
> can be either H, M, or L (High, Medium or Low).
> Columns M through Q are the Basic programs they take. If they are on the
> course they get an X in that column.
>
> If they have only applied for the course but have not taken it, then they
> are an A (applied) for the column.
>
> What I want to do is report how many inmates who are rated Low (or any
other
> rating) are taking courses in that array of columns (M, N, O, P and Q).
>
> I tried countif... but it counted the number of inmates marked L and added
> it to the number of X's in the columns M-Q.
>
> Can anyone help with this? I could not get sumproduct to work at all.
>
> Thanks for your patience...
> Nick.
>
>