Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: sumproduct

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i want to present data by quarters: R9 = 6/30/01 and Q9 = 3/31/01. what am i missing (or doing incorrectly)?

    thanks.


    =SUMPRODUCT((MONTH($C$9:$N$9)<=MONTH(R$9)>MONTH(Q$9))*$C11:$N11)

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-09 10:36, mcarter973 wrote:
    i want to present data by quarters: R9 = 6/30/01 and Q9 = 3/31/01. what am i missing (or doing incorrectly)?

    thanks.


    =SUMPRODUCT((MONTH($C$9:$N$9)<=MONTH(R$9)>MONTH(Q$9))*$C11:$N11)
    Hi,

    Try,

    =SUMPRODUCT((MONTH($C$9:$N$9)<=MONTH(R$9))*(MONTH($C$9:$N$9)>MONTH(Q$9))*$C11:$N11)

    You have to separate the >= and < tests into two distinct conditions.

    Bye,
    Jay

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    {=SUM(IF(MONTH($C$9:$N$9)=MONTH($Q$9)+{1;2;3},$C$11:$N$11))}

    Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •