I am using the below formula:
=SUM(SUMIFS(Data!$F:$F,Data!$A:$A,{"1822"},Data!$D:$D,{"ENIDDS.007"}))
I want the 1822 criteria, which is the week number, to increase by one when I drag it to the next column along. Is there a way to do this?
Thanks,
Sam
Bookmarks