Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct problem
ok, searched but couldn't find anything on my problem.
here is my formula: =SUMPRODUCT(($A$1:$A$10000=$N2)*($E$1:$E$10000=Q$ 1)*($E$1:$E$10000<R$1),$F$1:$F$10000) which work awesome, but the list in column A is serial numbers, which can be integers or alfa-numeric. and for some reason it wont pick up the integer values? any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT PROBLEM | Excel Worksheet Functions | |||
Problem using ADDRESS() in SUMPRODUCT() | Excel Discussion (Misc queries) | |||
Frustrating SUMPRODUCT problem. | Excel Discussion (Misc queries) | |||
SUMPRODUCT Problem | Excel Discussion (Misc queries) | |||
SUMPRODUCT problem | Excel Worksheet Functions |