View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default SUMProduct Part II

When I add an additional parameter in
--('Enroll I'!P$2:$P$2921="Regular")
I get the infamous, "#N/A" error.


Are there any #N/A errors already in that range?

If so, you should correct those formulas so they don't return #N/A.

--
Biff
Microsoft Excel MVP


"PAL" wrote in message
...
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?