+ Reply to Thread
Results 1 to 9 of 9

2 + 1 dimentional search

Hybrid View

jacknjob 2 + 1 dimentional search 05-12-2007, 02:42 AM
mudraker Do you mean Jane and 50 or... 05-12-2007, 02:58 AM
jacknjob oops 05-12-2007, 08:51 AM
jacknjob Help? 05-13-2007, 09:51 PM
duane what exactly do you want to... 05-13-2007, 09:59 PM
jacknjob I need this 05-13-2007, 11:16 PM
duane this is an array formaula so... 05-13-2007, 11:31 PM
duane actually Bryan's solution... 05-13-2007, 11:47 PM
jacknjob Thanks :) 05-13-2007, 11:48 PM
  1. #1
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    what exactly do you want to do? Find the total for June when jane and 40 are in columns a and b?
    not a professional, just trying to assist.....

  2. #2
    Registered User
    Join Date
    04-17-2007
    Posts
    30

    I need this

    I need to find the formula in the Result page that return a value from 2 columns + 1 row search.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    this is an array formaula so enter with control+shift+enter

    =OFFSET(Database!$A$1,MATCH(1,($C$1=Database!$A$2:$A$42)*($C$2=Database!$B2:$B42),0),MATCH($C$3,Database!$B$1:$N$1,0))

  4. #4
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    actually Bryan's solution should work as well

    =sumproduct(($c$1=database!$a$2:$a$42)*($c$2=database!$b$2:$b$42)*($c$3=database!$c$1:$n$1)*(database!$c$2:$n$42))

    this adds everyting in c2:n42 for which the critera for columns a and b are met, as well as the criteria for the column heading - which should be a unique solution, but if your data showed 2 rows having the criteria for example, the results would add

+ Reply to Thread

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