Sum formula that stays constant

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

What I would like is to have a format that a date will be
entered into A1. Cell A2:A... will have what will be the
number of items that came in at a certain point of the
day. In cell C2 I would like it to use a count formula if
the date is whatever is in A1 and when the date in A1
changes, I would like the summed data to remain in C2 if
that makes any sense. Thanks for the help.

Todd
 
Todd said:
What I would like is to have a format that a date will be
entered into A1. Cell A2:A... will have what will be the
number of items that came in at a certain point of the
day. In cell C2 I would like it to use a count formula if
the date is whatever is in A1 and when the date in A1
changes, I would like the summed data to remain in C2 if
that makes any sense. Thanks for the help.

Todd
Click to expand...

You can't do this with a worksheet formula; you would need a macro. The
reason for this is that it requires a memory of what the count was at a
particular point in time (an event) - when the date changed. Worksheet
formulas work on states, not events.
 
Back
Top