not sure what you're after here but one idea
say you have
.............A..................B..................C
1.......Date............Amount
2......1-Jan-05........500
3......1-Mar-05........20
which means you've sold 480 units over the period 1 Jan to 1 Mar
and you want to know the average number of items you sold per day then the
formula would be
=(B2-B3)/(A3-A2)
formatted as a number
if this isn't what you've after could you maybe type out an example or two
of what you have and what you're looking for (but please don't attach a
workbook)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
