Formulas

[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

 

[Pete_UK]

Try it this way:

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

Adjust the ranges to suit your data.

Hope this helps.

Pete

 

[Shane Devenshire]

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.