Sum Different dates

[sdsurzh]

Hi,


I have the following dates and i want the sum of each months.

24-Jan-13

28-Jan-13

31-Jan-13

01-Feb-13

05-Feb-13


Output:

Jan-13 3

Feb-13 2


Thanks,

Suresh Kumar S

 

[Kevin@Radstock]

Hi


A couple of ways of many, is the:

Assuming data is in A1:A5


SUMPRODUCT: =SUMPRODUCT(--(MONTH(A1:A5)=1))


SUMIFS: =COUNTIFS(A1:A5,">=01/01/2013",A1:A5,"<=31/01/2013") for Excel 2007>

Change month etc to suit.

 

[sdsurzh]

Thanks Kevin


I got the below formula from google search.

=SUMPRODUCT(--(TEXT($A$1:$A$1000,"mmm-yy")=TEXT(D1,"mmm-yy")))


Both works fine.


Thanks,

Suresh Kumar S

 

[Kevin@Radstock]

No problem Suresh Kumar, there are many ways. Also you can put your criteria in cells and reference them in your formulas.


Kevin