Hi!
.xls file attached
I have a worksheet called ShopInvoices which lists invoices I've sent out and the date they've been paid. I also have a sheet called WeeklySummary (I've simplified this in the above file to just show the invoice columns... in reality it also lists all shop cash sales) which I would like to have total the figures from ShopInvoices based upon which week the invoice was paid.
Is this possible? I have been working with VLOOKUP but the value to lookup has to be within the date range of the week (not just one date). And also, I don't know if VLOOKUP can be used to total up values which match the date range.
Can anyone shed any light on this for me?
Many, many thanks,
Matthew
Bookmarks