what exactly do you want to do? Find the total for June when jane and 40 are in columns a and b?
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.....
I need to find the formula in the Result page that return a value from 2 columns + 1 row search.
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))
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks