Formulas
 

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

Formulas
 

Try it this way:

=SUMPRODUCT((C1:C100="Y")*(A1:A100="Tyree"))

Adjust the ranges to suit your data.

Hope this helps.

Pete

On Feb 23, 5:21*pm, 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

Formulas
 

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