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
thydzikAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor 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
 
thydzikAuthor Commented:
genius, thank you, works well
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.