narnimar said:

Thanks. I get 1st quarter Sum using this formula. Now my question is -

1. how to get sum for 2nd 3rd and 4th Quarter?

=SUMPRODUCT(--(INT((MONTH($A$2:$A$13)+2)/3)=2),$B$2:$B$13)

or better, put the quarter number in a cell, say H1, and use

=SUMPRODUCT(--(INT((MONTH($A$2:$A$13)+2)/3)=H1),$B$2:$B$13)

etc.

2. how to get sum for each month?

put the month number in a acell and use

=SUMPRODUCT((--($A$2:$A$13<>""),--(MONTH($A$2:$A$13)=H1),$B$2:$B$13)

etc.