posted on Jun, 12 2007 @ 04:42 PM
Hi Guys, I'm hoping someone can help me with a little Excel problem I have.
I've got 2 columns of data on a spreadsheet - one is dates, and the one beside it is sales.
I need 2 functions.
One is to total the sales within a given time period e.g. 1st January - 31st January
The second is to count the number of days within that given range that there were sales e.g. 5 days between 1st and 31st of January.
If you need any more info, please U2U me and I can mail or IM you a sample copy of the spreadsheet I'm trying to create.
Many thanks in advance