Need your help, through SUMIFS formula, I need the result to be like the one in D5 column. From the formula box in picture, we can see that I wanted to know the ad cost between July 6 to July 8 which data is referred from table range of G4:K7 and the date-range is referred from cells range C1:C2
I need the formula of 'H5:H7' (in yellow) like stated in the formula box in below picture to be replaced, in order to be automatically detected (as far as I know we have to use INDEX & MATCH formula to replace the 'H5:H7').
So then, say, when I make the formula for D6 column, I don't need to change H5:H7 (in yellow at formula box below) into I5:I7 manually anymore to refer the 'Revenue' in I5:I7.
I have tried something like:
(index((H5:K7),,match(C5,(H4:K4),0) to replace H5:H7 in yellow below but it didn't work. What should be the replacement formula for H5:H7 instead of the one I've tried already in above?