Making Excel 03 count product usage by month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I need a way to track product usage by months in MS Excel 2003. I need to
enter the start date of a period, which could be in the middle of a month,
and the end date of the period, which could be any time about 190 days later.
I need to know the usage of the product per month. I know how much of the
product will be used each day, which will vary each day in the period. My
problem is that I need to be able to make excel start a new count of the
product and output it when the first of each month is reached in a given
period. Hopes that is enough info. Thanks!
 
Why not just record the usage each day and then use sumif against your data

=sumif(A:A,">=Feb 15, 2007",B:B)-Sumif(A:A,">Aug 24, 2007",B:B)
 

Ask a Question

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.

Ask a Question

Back
Top