mcarter973
Board Regular
- Joined
- Mar 24, 2002
- Messages
- 83
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)
thanks.
=SUMPRODUCT((MONTH($C$9:$N$9)<=MONTH(R$9)>MONTH(Q$9))*$C11:$N11)