Lookup question...

[Bud1960]

Hi!

I have 3 columns; colA = Instructor name, colB = term, and colC =
activity code. colC has either an A or a D in it. What I would like to
do is return the number of A's in colC, but only those that pertain to
each unique record in both colA and colB.

Is there any way of doing this by selecting the three columns?

Thanks!

 

[Don Guillett]

more explanation along with an example always helps

 

[Bud1960]

Ok, I'll try this again...

I have 3 columns with data in.

Column 1 has the Term associated with the data in the next 2 cells nex
to it.

Column 2 has a code, (N)ew, (R)eturning, or (F)ormer student.

Column 3 has 1 of 2 codes that show if the student has (D)ropped o
(A)dded a course.

I would like to know if there is a way by selecting all the data in th
3 Columns that I can return a table of information that reflects th
number of New students that Dropped a course in a specific Term.

If that is not clear, I will try again, but I cannot post the fil
because it contains sensitive data.


Thanks

 

[Don Guillett]

IF I understand your needs
=sumproduct((rngA="Term 1")*(rngC="dropped)*1)
example
=SUMPRODUCT((A2:A200="term 1")*(C2:C200="dropped"))
if you have numbers in col a
=SUMPRODUCT((A2:A200=1)*(C2:C200="dropped"))
for new students that dropped
=SUMPRODUCT((A2:A200="term 1")*(B2:B200="new")*(C2:C200="dropped"))

 

[Bud1960]

Thank you very much! That is exactly what I wanted! :

 

[Don Guillett]

glad to help