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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct problem
Sounds like either column A and/or N2 may be formatted as TEXT.
Try this: Select an empty cell. Copy that empty cell Select your range in column A and/or N2 Then do: EditPaste specialAddOK Biff wrote in message ps.com... 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? |
Reply |
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 |