N

#### Narnimar

A2 B2

01/01/2008 43

02/02/2008 32

03/03/2008 43

04/03/2008 54

05/04/2008 5

06/05/2008 32

07/06/2008 75

08/07/2008 3

09/08/2008 23

10/08/2008 64

11/09/2008 76

12/09/2008 43

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

N

A2 B2

01/01/2008 43

02/02/2008 32

03/03/2008 43

04/03/2008 54

05/04/2008 5

06/05/2008 32

07/06/2008 75

08/07/2008 3

09/08/2008 23

10/08/2008 64

11/09/2008 76

12/09/2008 43

B

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

N

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

2. how to get sum for each month?

B

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.

N

But your formula returns error message for my Question 2. The pop up with

mesage that "the formula you have entered has an error"

B

One bracket too many

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

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

N

Bob Phillips said:One bracket too many

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

--

__________________________________

HTH

Bob