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.