Forum Discussion
SUMIFS Query
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?
I have attached a basic spreadsheet with the basic principle of what I would like to achieve.
Thanks,
Sam
2 Replies
Hi Sam,
Why don't you use something like
=SUMIFS(Data!$C:$C,Data!$A:$A,C$1,Data!$B:$B,$A2)
? Please see attached.
Perfect Sergei!
Thank you so much for your help, it really is much appreciated.
Sam
