Rolling Monthly Amounts to Annual Monthly Amounts

R

RV

I have a spreadsheet that reports sales on a rolling monthly basis: Aug 2005
- Jul 2006 this month, Sept 2005 - Aug 2006 the next month, and so on.

I need to create a annual report by Jan - Dec using the rolling monthly data
each month.

Want to enter amounts into the rolling monthly report and have the same
information on the annual report.

Is this done by a VLOOKUP function? What formula would I use? Need to
help!!!
 

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

Similar Threads

Like to start using Access 1
Rolling 12 month 9
Calculating total amount in a Pivot Table 1
Compiling Revenue Reports 1
Average Non-consecutive Cells 4
Calculate tiered commisions on commulative monthly sales 1
Summary of shipments by month 5
Select a range of cells 2

Top