Hi there - If you have a moment to help me out I would greatly appreciate it. I am missing something simple or maybe I need to completely change the formula.
Attached is a simple spreadsheet (the #'s are irrelevant I am making them up). I am trying to have Excel find the Quarter and the Revenue type along the top and match them, then provide me that #.
I assume that it fails because there are multiple columns with the same heading (NEW is repeated in row 2) and (Q1'21, Q2'21 etc is repeated in row 3). Is that my problem?
If so, how could I have excel find those 2 criteria and then provide me the specific # for say Q2'21 renewal in Latin? I was using a vlookup which works, but of course I run the risk of down the road shifting things around and losing some reference.
Any help would greatly be appreciated!
This is my formula: =+SUMIF($A$4:$A$9,$A20,INDEX($B$4:$AD$9,0,MATCH($C20,$B$3:$AD$3,0)*MATCH($B20,$B$2:$AD$2,0)))
Thank you!
Bookmarks