Hi,
a possible approach
=SUM(INDEX(C4:Q8,MATCH("Team 1",B4:B8,0),MATCH("ACTUALS",C2:Q2)):INDEX(C4:Q8,MATCH("Team 1",B4:B8,0),MATCH("CONFIRMED",C2:Q2,0)-1))Cheers=SUM(INDEX(C4:Q8,MATCH("Team 1",B4:B8,0),MATCH("Confirmed",C2:Q2)):INDEX(C4:Q8,MATCH("Team 1",B4:B8,0),MATCH("Unconfirmed",C2:Q2,0)-1))
Last edited by canapone; 10-14-2014 at 07:45 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks