jeffmoseler
Well-known Member
- Joined
- Jul 16, 2004
- Messages
- 540
I have the following formula in a cell:
=SUMPRODUCT(--(MONTH(Prospects!$AO$12:$AO12)=B1),--(YEAR(Prospects!$AO$12:$AO12)=$A$8),Prospects!$AQ$12:$AQ12)
When I add a row at line 12, it changes the formula to read:
=SUMPRODUCT(--(MONTH(Prospects!$AO$13:$AO13)=B1),--(YEAR(Prospects!$AO$13:$AO13)=$A$8),Prospects!$AQ$13:$AQ13)
How do I write this so that Row 12 stays at 12 and the bottom row grows as I add them. So it should read:
=SUMPRODUCT(--(MONTH(Prospects!$AO$12:$AO13)=B1),--(YEAR(Prospects!$AO$12:$AO13)=$A$8),Prospects!$AQ$12:$AQ13)
=SUMPRODUCT(--(MONTH(Prospects!$AO$12:$AO12)=B1),--(YEAR(Prospects!$AO$12:$AO12)=$A$8),Prospects!$AQ$12:$AQ12)
When I add a row at line 12, it changes the formula to read:
=SUMPRODUCT(--(MONTH(Prospects!$AO$13:$AO13)=B1),--(YEAR(Prospects!$AO$13:$AO13)=$A$8),Prospects!$AQ$13:$AQ13)
How do I write this so that Row 12 stays at 12 and the bottom row grows as I add them. So it should read:
=SUMPRODUCT(--(MONTH(Prospects!$AO$12:$AO13)=B1),--(YEAR(Prospects!$AO$12:$AO13)=$A$8),Prospects!$AQ$12:$AQ13)