I have a table of data that's associated with a channel, metric (rows) and months (column).
I'm trying to create a view like below where it summarizes the data depending on what time frame the user wants to see. B3, C6 and C9 are hard-coded inputs. Based on those inputs, I'm trying to figure out what the formula is for C14:E16. I think it's some combination of SUMIF and INDEX MATCH, but I haven't been able to figure out how to best structure the formula.
Thanks for the help in advance.
I'm trying to create a view like below where it summarizes the data depending on what time frame the user wants to see. B3, C6 and C9 are hard-coded inputs. Based on those inputs, I'm trying to figure out what the formula is for C14:E16. I think it's some combination of SUMIF and INDEX MATCH, but I haven't been able to figure out how to best structure the formula.
Thanks for the help in advance.