How to get YTD Summary

Z

zy1972

Hi,
I have a 12-m sales number. I know it is easy to get MTD number by using
vlookup, but is there a way to get YTD number when month changes?

For example, if I use a cell to input month, then use vlookup to get a
number. Then this number is used in vlookup to get MTD number. Could I use
the Month Input to get a YTD number. for example, if I put April , MTD shows
7, and YTd shows37?

A1 A2
A13
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales 12 13 5 7 8 9 10 11 1 2 3 6

D1 D2
Jan 2
Feb 3
Mar 4 ...
 
S

ShaneDevenshire

Hi,

The following formula will do the trick, it assumes your titles are on row 1
with Jan in B1. The data directly below it. I put the month you want into
cell A5.

=SUM(OFFSET(A2,,1,,MATCH(A5,B1:M1,)))
 
D

dhstein

If Cell E9 is the Month and your sales figures are in B2: M2 then use this
formula:

=SUM(INDIRECT("B2:"&CHAR(E9+66)&"2"))
 
Z

zy1972

Thank you so much. I tried it and it works. Actually this question has
bothered me for a while. Now it is all solved. Thanks,
 

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

Top