Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Similar to previous query. Is there anyway to include an operator in an
external reference to a sumproduct formula. For example, if the formula is =sumproduct((A1:A10=A12)*(B1:B10=B12)) is there any way to have <6 in A12 or 8 in B12? I have figured out how to include multiple single values but not sure if an operator as described can exist in a reference cell (probably not since it doesn't seem to work; but is there a way to do it?) thanks anand |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct external reference | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |