Possibly there's already a #N/A error in range ''Enroll I'!$O$2:$O$2237
??

"PAL" wrote in message
...
I have 3 worksheets.

The first worksheet contains a column that has text in it and is formatted
so.
The second worksheet, uses VLOOKUP to bring that value over.
The third worksheet uses SUMPRODUCT. The formula worked prior to adding
the
parameter described above. The formula is:

=SUMPRODUCT(--('Enroll I'!$O$2:$O$2237="Regular"),--('Enroll
I'!$E$2:$E$2237<" Open"),--('Enroll I'!$M$2:$M$2237="Yes"),--('Enroll
I'!$H$2:$H$22370),--('Enroll I'!$N$2:$N$2237="No Data"))

This is the only new peice: ('Enroll I'!$O$2:$O$2237="Regular"). I get the
#N/A error.

I have tried changing the formating on the second worksheet but it is not
flying. Ideas?