Re: monthly & quarterly Summery

One bracket too many

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

--
__________________________________
HTH

Bob

"narnimar" <narnimar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4A5C5033-FB56-44BD-8478-7259F80377D0@xxxxxxxxxxxxxxxx
The answer for Question No. 1. is working perfect!
But your formula returns error message for my Question 2. The pop up with
mesage that "the formula you have entered has an error"

"Bob Phillips" wrote:



"narnimar" <narnimar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:826E848C-A9F3-4459-994F-FF14F140D778@xxxxxxxxxxxxxxxx
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.





.

Relevant Pages

  • Re: problems with Perl RegEx match
    ... Missing right bracket at ./LogPreProcessor_Inetprod.pl line 64, ... Perl didn't encounter it. ... when I used the following search term in google to look ... considering it's an error message from an older Perl - in newer Perls, ...
    (comp.lang.perl.misc)
  • Re: monthly & quarterly Summery
    ... "Bob Phillips" wrote: ... But your formula returns error message for my Question 2. ... mesage that "the formula you have entered has an error" ... put the month number in a acell and use ...
    (microsoft.public.excel.misc)
  • Insert Text
    ... I'm inserting a mesage into a text field. ... However when there is a comma in ... it gives me an error message. ...
    (microsoft.public.access.modulesdaovba)