I'm trying to combine match with indirect so that it sums up the entire column once it matches a text value in a particular but I've been having trouble getting it to work.
Help would be greatly appreciated.
Open in new window
Your 2 MATCH formulas are going to return the column number where the value in B250 is found in row 5.
For example if the value in B250 was found in column 5 you would be summing row 5.