Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMProduct Part II
I am working with this formula and it works great.
=SUMPRODUCT(--('Enroll I'!A$2:$A$2921=$B17),--('Enroll I'!$O$2:$O$2921="NSITE0"),--('Enroll I'!M$2:$M$2921="Yes"),--('Enroll I'!N$2:$N$2921="Yes")) When I add an additional parameter in --('Enroll I'!P$2:$P$2921="Regular") To look like this.... =SUMPRODUCT(--('Enroll I'!A$2:$A$2921=$B17),--('Enroll I'!$O$2:$O$2921="NSITE0"),--('Enroll I'!M$2:$M$2921="Yes"),--('Enroll I'!N$2:$N$2921="Yes")),--('Enroll I'!P$2:$P$2921="Regular")) I get the infamous, "#N/A" error. The page I am referencing, 'Enroll I", gets the value from another sheet. It seems to be in the right format -I have tried, General or Text. I have also tried w and w/o the array symbols. Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct using part of a Cell | Excel Discussion (Misc queries) | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
sumproduct of part cells of a range with blanks | Excel Discussion (Misc queries) |