sumproduct

[mcarter973]

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)

 

[Jay Petrulis]

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

 

[Mark W.]

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