Is there anyone who can help with this?
Is there anyone who can help with this?
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