Hello,
I have a unique issue dealing with a running total with criteria and conditionals to make it calculate successfully . I've spent the past two days reading over forum posts and help documents and haven't yet been able to make headway. I have experience in BASIC, but I only want to turn to VBA as a last resort, as I plan on having the spreadsheet run on smartphones by friends and fellow co-workers and would like to minimize any security risks that come with enabling macros with inexperienced end users.
What I'm trying to do is have a column of daily totals summarized in the adjacent columns: a 7 day total and a 8 day total. It will calculate, including the current day, a running count of both the last 7 days and 8 days.
My problem lies with having a "reset" day in which the running totals are reset and begin counting over. These "reset" days could come at any time during the month, and happen more than once a week.
I've tried my best at attempts to create a formula string consisting of SUM, ADDRESS, MIN, MATCH and a few other functions that have resulted in failures. I can't wrap my head around this at all.
Attached is an example of what I'm trying to do. Note that some days the totals could be zero (0) but do not denote a "reset" day. Only the daily totals column will be manipulated by the user. I would like both the 7 and 8 day totals to dynamically calculate per the user's entry.
Any help or direction would be extremely appreciated. I'm at my wits end.
Much Thanks,
Jones
Bookmarks