Formula Help

  • Thread starter Thread starter aea2517
  • Start date Start date
A

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
 
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?
 
Back
Top