How do I set up a COUNTIF with more than one condition?
Most excellent! Thank you, Mark, that works like a charm. And looks like I
could go on extending the set of conditions -- very nifty!
Gail
"Mark Driscol" wrote:
See if something like the following will work for you.
=SUMPRODUCT((B1:B10="Dsci")*(C1:C10="EER")*(D1:D10 ="RA"))
Mark
Gail wrote:
I'm using Excel [MS Office 2000 Professional in Windows XP] to list new and
continuing students and want to set up a summary sheet that captures numbers
of students by category. The lists are set up with a column each for degree
program, concentration, specific interest, admission date, graduation date,
etc.:
Student Name / degree / concentration / interest ...
In the summary sheet, I want to tally a count of students in a cross-section
of categories -- the number of DSci students, for example, in the EER
concentration who have a specific interest in RA.
Q1: How can I set up a COUNTIF to include a number of conditions -- that
is, to count those entries where (value in col B = DSci) and (value in col C
= EER) and (value in col D = RA)?
Q2: is there a different way to get at cross-category counts without using
COUNTIF?
Gail
|