Hi,
I have this formula
=SUMIF('1'!$D$4:$D$10,$B5,'1'!$G$4:$G$10)
I need the sheet number to increase as I drag it across, everything else does as it should.
I've used indirect before, but can't see how to fit it in here.
Thanks
Hi,
I have this formula
=SUMIF('1'!$D$4:$D$10,$B5,'1'!$G$4:$G$10)
I need the sheet number to increase as I drag it across, everything else does as it should.
I've used indirect before, but can't see how to fit it in here.
Thanks
Last edited by P4r4gon; 09-17-2016 at 10:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks