Formulas

  • Thread starter Thread starter Dnoonan
  • Start date Start date
D

Dnoonan

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
 
Try it this way:

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

Adjust the ranges to suit your data.

Hope this helps.

Pete
 
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.
 
Back
Top