Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=SUMPRODUCT(($D$2:$D$23=$A28)*($C$2:$C$23=10)*($e $2:$e$23,NONBLANK))
I knoe the first 2 legs of the formula work, i am already using them. all i want to add in the new call is another criteria: that being when e2:e23 are not blank. What do I put where NONBLANK is in my formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct Help | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions |