Thanks:  0
Likes:  0

1. 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. 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. {=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.

## User Tag List

#### Posting Permissions

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