Results 1 to 4 of 4

SUMPRODUCT problems

Threaded View

eric_t_viking SUMPRODUCT problems 05-28-2009, 01:39 PM
NBVC Re: SUMPRODUCT problems 05-28-2009, 01:51 PM
eric_t_viking Re: SUMPRODUCT problems 05-28-2009, 02:02 PM
NBVC Re: SUMPRODUCT problems 05-28-2009, 02:20 PM
  1. #1
    Registered User
    Join Date
    05-14-2009
    Location
    mancheter, england
    MS-Off Ver
    Excel 2007
    Posts
    21

    SUMPRODUCT problems

    losing the will to live on this one, probably because it is another simple problem I can't solve

    What I'm trying to do is search a range of cells for a range of values AND then see if it matches one other value in another range of cells.

    In this case,

    =SUMPRODUCT((T3:T49="P6")+(T3:T49="P5")+(T3:T49="P4")+(T3:T49="P3"))*(U3:U49="w")

    T3:T49 can equal P6 or P5 or P4 or P3 but the cells can only be counted if U3:U49 is 'w' as well

    Thanks for your help
    Last edited by NBVC; 05-28-2009 at 04:36 PM.

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