Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumproduct
I have the following sumproduct formula it is calculating one colomn . But the problem coming when somebody trying to delete one row inbetween then inside the formula cell number is decreasing =SUMPRODUCT((COURIER!B4:B996=TODAY())*(COURIER!D4: D996="S")*(COURIER!C4:C996)) like this. It was B1000 when i made first. any solution for not to reduce the number. Secondly i wanted to change the 996 to the end of excel limit (65536)any short cut to write this. thanks alot with regards nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=388286 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
sumproduct | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct #value! | Excel Worksheet Functions |