Hi,

what is Y+Y? Are you sure you really want to add the Y's?

Suppose you really want to count:

2007:

=COUNTIFS(C1:C10,"Y",A1:A10,"Tyree")

you already have a good suggestion for 2003 from Pete.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Dnoonan" wrote:

Hi,
I need help, I know what I want to do, I just don't know how to do it.

Add all the (Y)'s in column C, but column A has to say (Tyree).

Thanks
Diane