Jan Hoffmann
New Member
- Joined
- Jun 27, 2007
- Messages
- 17
Hello,
I'm stuck with a lookup-problem. I have a table showing monthly sales for customers with "Customer Name" in column A and month in the header row.
So now I want to do a Moving Annual Total lookup function, which for a given month and customer, look up the sales for the given month and accumulate it with the previous 11 month, so that it shows a 12-month total. Eg. typing in Customer Z and the month January 2009, the calculated cell returns the total sale for customer Z in the period February 2008 to January 2009.
I hope you can help me with this problem - Thank you in advance!
Best regards
Jan Hoffmann
I'm stuck with a lookup-problem. I have a table showing monthly sales for customers with "Customer Name" in column A and month in the header row.
So now I want to do a Moving Annual Total lookup function, which for a given month and customer, look up the sales for the given month and accumulate it with the previous 11 month, so that it shows a 12-month total. Eg. typing in Customer Z and the month January 2009, the calculated cell returns the total sale for customer Z in the period February 2008 to January 2009.
I hope you can help me with this problem - Thank you in advance!
Best regards
Jan Hoffmann