# dynamic summing in excel, total vlaues for each month

here is what I am trying to do, I have the following dates in a single column
1/3/10
2/3/10..
30/3/10
31/3/10
1/4/10
2/4/10...
30/4/10
31/4/10
1/5/10..

In a second column I have some values for the dates.
In a second sheet I have keys of the 1st of each month, for each month I would like the sum, please let me know how I would do this.

Book1-example.xlsx
LVL 11
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Hello thydzik,

You can use SUMIFS function, i.e. use this formula in D4 copied down

=SUMIFS(values!B:B,values!A:A,">="&A4,values!A:A,"<="&EOMONTH(A4,0))

see column C on the attached

regards, barry
26914583.xlsx
0

Experts Exchange Solution brought to you by