Hi
Im trying to add an index match into a sumifs formula but cant get it to work.
I've tried
=SUMIFS(INDEX($C$5:$AB$500,,MATCH(A$2, $C$3:$AB$3, 0)),$B:$B,">="&A3,$B:$B,"<="&A4)
C5:AB500 is my data field
A2 is the item im looking for
C3:AB3 is the list of items(headers)
Column B is dates
A3...