SUMProduct Part II
Hi,
Although your formula has a closing parenthesis in the wrong place that
should not return an #N/A error message, just an incorrect result possibly.
Check the range 'Enroll I'!P$2:$P$2921 there is probably a formula in that
range returning and #N/A
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"PAL" wrote:
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?
|