3 Questions
On Sat, 10 Nov 2007 08:35:30 -0600, "Django Cat" < wrote:
2. I'd like to add a further column that keeps a running sales figure for the week. To do this it needs to check back to locate a date 7 days before the current date, and then add all the Column C figures up to the current transaction. There could be any number of transactions on any given date. Is this possible?
=SUMIF(Date,"="&A10-7,Money)-
SUMIF(Date,""&A10,Money)
will return transactions during the last 7 days prior to (and including) the
Date in A10.
If you need the current week, and Day 1 of the week is Sunday, then:
=SUMIF(Date,""&A10-WEEKDAY(A10),Money)-
SUMIF(Date,""&A10,Money)
--ron
|