Sumproduct... or Countif

  • Thread starter Thread starter Barney Quinn
  • Start date Start date
B

Barney Quinn

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))
 
Back
Top