How do I add consecutive numbers but start over at break in the.
Recently, the following question was posed by another party:
"How do I add consecutive numbers but start over at a break in them. I'm
trying to calculate consecutive days of attendance. One might have had 20
days in a row missed one and then I need to start over."
The rsvp was:
You received an answer...
In B1 enter:
=--(A10)
In B2 enter:
=(A20)*(1+B1)
and drag down to copy as needed
My question is:
What does =--(A10) mean?
i.e. what is the meaning of...=-- ??
Regards,
FL KULCHAR
|