Hello -
I'm a relativley inexperienced excel user, and am having trouble using
multiple criteria for a countif function. I've looked through two books
and the FAQ here, and am striking out (seems simple, so I know I'm
missing something easy).
I'm trying to have a cell display the total number of entries in a
column that fit criteria in two other columns.
For example, in the below, I'd like to know how many names in Column A
are both Blue (Column B) and Low (Column C)
A B C
1 Roger Blue High
2 Mike Red High
3 Fred Blue Low
4 Casey Red Low
5 John Blue High
6 Jeff Red Low
I think this is a COUNTIF function, but I can't figure out how to make
the AND work. If anybody could offer any thoughts, I'd be very
appreciative.
Thanks,
Chris
--
allphin
------------------------------------------------------------------------
allphin's Profile:
http://www.excelforum.com/member.php...o&userid=27337
View this thread:
http://www.excelforum.com/showthread...hreadid=468379