Formula Help

[aea2517]

I need help setting up the following cell formulas. Can anyone help with this?
You'll notice Y changes value depending on it's juxtaposition to N.
Oct Nov Dec
Y Y Y 33 =10+11+12
Y Y N 21 =10+11+0
N Y Y 21 =0+10+11
Y N Y 20 =10+0+10
Y N N 10 =10+0+0
N Y N 10 =0+10+0
N N Y 10 =0+0+10
N N N 0 =0+0+0

 

[David Biddulph]

=10*COUNTIF(A2:C2,"Y")+AND(A2="Y",B2="Y")+AND(B2="Y",C2="Y")+(COUNTIF(A2:C2,"Y")=3)

 

[xlm via OfficeKB.com]

Hi

I don't understand what you want to do.
Do you want to change the N to Y if the value change to > 0 or .....
Where can these numbers be found, in the same sheet or others and
which cells are they in?

HTH

Pls click the Yes button if this help

cheers, francis

 

[aea2517]

Dear David,
Thanks so much, it's perfect.
Ann

=10*COUNTIF(A2:C2,"Y")+AND(A2="Y",B2="Y")+AND(B2="Y",C2="Y")+(COUNTIF(A2:C2,"Y")=3)

 

[aea2517]

Thank you so much for your quick response that was extremely helpful. Would
I be able to use this formula to calculate a full year instead of just 3
months?

 

[T. Valko]

see your other post