Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT 00-Jan-00
Hello,
I am using following formula, when Sheet = Payment cell D9:D1000 doesn't match value = Clear error value is coming in $K614 00-Jan-00 which I really don't want, I just want as empty cell, is there any solution ? =SUMPRODUCT((Payment!$G9:$G1000=$K614)*(Payment!$D 9:$D1000="Clear"),(Payment!$W9:$W1000)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SUMPRODUCT help | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
hlp with sumproduct! | Excel Worksheet Functions | |||
sumproduct help | Excel Worksheet Functions |