View Single Post
  #1   Report Post  
FLKULCHAR
 
Posts: n/a
Default 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