| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT is showing wrong Amount
I am finding that with the below calculation I am finding that SUMPRODUCT is
obtaining the wrong # of items. I have a column with 12 names that are issuing this command for each command, some of the names it works, some it doesn't - has anyone seen this before... =SUMPRODUCT(--('worksheet1'!AD2:AD2000="BUTTON"),--('worksheet1'!U2:U2000="LATITUDE C610")) When I use the "FILTER" on the spreadsheet I actually get the correct # - is there something I am doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT is showing wrong Amount
The first thing I'd check is the referenced ranges. Does the data list stop
at row 2000 or is there data below that row? Does that help? *********** Regards, Ron XL2002, WinXP-Pro "msbutton27" wrote: I am finding that with the below calculation I am finding that SUMPRODUCT is obtaining the wrong # of items. I have a column with 12 names that are issuing this command for each command, some of the names it works, some it doesn't - has anyone seen this before... =SUMPRODUCT(--('worksheet1'!AD2:AD2000="BUTTON"),--('worksheet1'!U2:U2000="LATITUDE C610")) When I use the "FILTER" on the spreadsheet I actually get the correct # - is there something I am doing wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT is showing wrong Amount
I figured out after viewing at for the 100th time that I was referencing two
different worksheets for the values below - THanks "msbutton27" wrote: I am finding that with the below calculation I am finding that SUMPRODUCT is obtaining the wrong # of items. I have a column with 12 names that are issuing this command for each command, some of the names it works, some it doesn't - has anyone seen this before... =SUMPRODUCT(--('worksheet1'!AD2:AD2000="BUTTON"),--('worksheet1'!U2:U2000="LATITUDE C610")) When I use the "FILTER" on the spreadsheet I actually get the correct # - is there something I am doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct, By Quarters and Amount | Excel Worksheet Functions | |||
| SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
| IF function displays wrong amount | Excel Worksheet Functions | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Linear Mode
