Even though your data is in a spreadsheet, Excel is probably NOT the best
vehicle for this.

Do you have all your customers in the same spreadsheet, or just one per sheet?
You said you need to ignore weekends. What about holidays?
Is there one line per day per customer, or do you need to aggregate data
into a single days' activity?

Finally, do you MS Access or another database?

"Peanut" wrote:

I have a spreadsheet that records the daily activity of a customer's account.
Due to various limits on how much each customer is allowed to utilize their
accounts, I have been charged to record, within a certain time frame (the
most recent month), the sum of 3 consecutive days of activity. However, I
need to report the sum of the 3 consecutive days with the largest level of
activity to gauge if the customers "toe the line" at any time. And for
another wrench in the formula - I need to ignore weekends, but still
recognize weekdays with no activity.

Help!