Hello!
I have 3 columns with values, Test1, Test2 and Time. I would like to know the value of Time when Test1 = X and Test2 = Y. Attached is my clear example . Thanks!!!
-Luis
Hello!
I have 3 columns with values, Test1, Test2 and Time. I would like to know the value of Time when Test1 = X and Test2 = Y. Attached is my clear example . Thanks!!!
-Luis
It's not quite a clear example.... there are 3 Test A's of 0 and Test B's of 2... what if those were the inputs? Do you want first Time or sum of all the Times that match?
If you want sum, then try:
=SUMPRODUCT(--($A$2:$A$11=F2),--($B$2:$B$11=G2),$C$2:$C$11)
if you want first match:
=INDEX($C$2:$C$11,MATCH(1,INDEX(($A$2:$A$11=F2)*($B$2:$B$11=G2),0),0))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Wow, you actually answered my second question without me even asking it :D
I meant the first match. Next time ill try to be more precise with my question.
Thanks a lot!!!
-Luis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks