Results 1 to 12 of 12

SUMPRODUCT formula not working

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2009
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    76

    SUMPRODUCT formula not working

    Hi,
    I have been using the following formula successfully just by changing the names. For example I can change it from "Jennifer" to "Michael" to obtain my data successfully.

    =SUMPRODUCT(--('Paste Query Results Here'!$A:$A="Jennifer"),--('Paste Query Results Here'!$D:$D<>"NOT"),--('Paste Query Results Here'!$K:$K<>"K12"),--ISNUMBER(MATCH('Paste Query Results Here'!$D:$D,{"ADMIT","CANC","DENY","PEND","STU","WDRAW","CANCX","CANPX"},0)))

    However, I need to be able to change my formula to pull data for everyone else than my main 8 names. I tried this but it didn't work:

    =SUMPRODUCT(--('Paste Query Results Here'!$A:$A<>"Michael","Reggie","Jennifer","Hortencia","Matthew","Amanda","Alex","Virginia),--('Paste Query Results Here'!$D:$D<>"NOT"),--('Paste Query Results Here'!$K:$K<>"K12"),--ISNUMBER(MATCH('Paste Query Results Here'!$D:$D,{"ADMIT","CANC","DENY","PEND","STU","WDRAW","CANCX","CANPX"},0)))


    Please help! What am I doing wrong or missing? Your assistance would be greatly appreciated.
    Last edited by KINNEY0201; 09-29-2010 at 08:12 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1