Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT FORMULA
I AM GETTING #VALUE! ERROR WHEN I USED BELOW FORMULA.
=SUMPRODUCT(IF(D4:D1055="M",SUMPRODUCT(--($L$6:$L$1055="New"),--($N$6:$N$1055="Cisco Systems Capital Australia P/L")),"")) PLEASE HELP. THANKS. DINESH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumProduct Formula Help | Excel Worksheet Functions | |||
do I need array formula or sumproduct for counting? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
sumproduct formula to slow | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |