VLOOKUP and SUMPRODUCT

  • Thread starter Thread starter PAL
  • Start date Start date
P

PAL

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$2237>0),--('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?
 
This is the only new peice: ('Enroll I'!$O$2:$O$2237="Regular"). I get the
#N/A error.


Replace a new peice with this one:

(ISNUMBER(SEARCH("Regular",'Enroll I'!$O$2:$O$2237)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMProduct Part II 5
SUMPRODUCT 3
SUMPRODUCT 3
Many ifs.... 1
Scrabble Value calculation for Welsh words 0
Complex if 9
insert new row and copy formula 1
Calculation with EDATE Help Needed! 2

Back
Top