Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT
I have a sumproduct
=SUMPRODUCT(--(ProblemClosedDate=$D24),--(ActionClosedDate<" "),--(LOB=$E24)) which is filtering down on the 3 defined names, all having the same similiar reference, i.e. =OFFSET('RCA Tracker'!$O$1,0,0,COUNTA('RCA Tracker'!$AG:$AG),1) It used to work fine however, I have changed column O which is the ProblemClosedDate not to be a manually inputted date but auto populated, hence it is now =IF(AC812=1," ",IF(AE812,AE812," ")) If the sumproduct was =D24 then it would work but since I need it as = it returns far to many. Do I need to use INdirect and if so should it be in the defined name or the sumproduct, either way have you the text since i don't know the syntax? thx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions | |||
Using SumProduct in VB | Excel Discussion (Misc queries) | |||
Sumproduct | Excel Worksheet Functions |