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!