RE: Formula Help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Not the most elegant but it works
Assume that your "Y" and "N" are in columns F - Q

Starting in column S enter the equation
=IF(F11="N",0,IF(AND(E11<>"Y",F11="Y"),10,R11+1))
and copy that across to column AD

Adjust the rows and columns as necessary...

If this helps - click yes this answers the question.
--
Wag more, bark less


"Erika" wrote:

I have a spreadsheet with sales reps and I am tracking points if they make
their month or not. So for example

Jan Feb Mar April May June
John Doe Y N Y Y Y N
=10+0+10+11+12+0
Jane Smith N Y Y N Y Y
=0+10+11+0+10+11+12

I am trying to find a way to get a grand total - each month I come in the
spreadsheet and enter either a Y or a N. If they make their month they get
10 points, if they make their month the next month they get 11 points however
if they don't start over. The trick is if they don't make their month and
get a zero next they start back over at 10 and increase from there. I need
to track this for an entire year and keep a running total.

Any ideas?
.

Relevant Pages

  • Return of an argument @ given value of function
    ... Certainly, straighforward solution is to adjust a function> at every step to zero and use "fzero", but it seems like not the most elegant and efficient way. ... There is no shame of abusing the trick. ...
    (comp.soft-sys.matlab)
  • Re: 19v2000 vector monitor HV adjustment
    ... should be 14.5KV at the anode with the beam current at zero. ... "Beam current at zero" that has me confused. ... and then adjust away. ...
    (rec.games.video.arcade.collecting)
  • Re: 19v2000 vector monitor HV adjustment
    ... "Beam current at zero" that has me confused. ... and then adjust away. ... So I put in my spare HV cage only to find the voltage at around 10KV ...
    (rec.games.video.arcade.collecting)
  • Re: Daewoo Puma lathe and Fanuc 18T thread start orientation
    ... The zero pulse ... marker for threading is the same zero for the C-axis plus or minus any ... The easiest way to do this is to adjust you Z-axis start point for the ... shift it using a coordinate setting command. ...
    (alt.machines.cnc)