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