Hi All,
This is my first post in any forum, so please be gentle.
I have a formula that references cells from other sheets within the same workbook. Its a workbook that calculates times that workers spend on a job with a unique job number over a number of days from individual workers time sheets and then converts to a cost in a single cell on another costing sheet.
Most of it I have worked out, but for every job number created, I am having to manually type in a formula which looks for the unique job number on the timesheets. I have been copy and pasting most of the formula and manually punching in the unique job number to look for.
Please see formula below:
=SUMIFS('KRIS LAB'!L:L,'KRIS LAB'!B:B,"=3424")
I have that formula in 6 adjacent columns, with only the workers name changing in each (Saul, Nick, Billy, Tom, Cameron)
How can I drag that row, but increment the numerical part only so the next row keeps everything the same but ends in 3425, and then the row after 3256 etc...?
I have tried selecting one row and when I drag, it make duplicates of the same formula with same job number. If I select 3 or 4 rows, when I drag, it repeats those same 3 or 4 job numbers over and over.
Job numbers are formatted as 'number'. Not sure if this matters, but I'm trying to give as much info as I can to aid a speedy solution if possible.
Any help would be greatly appreciated and would save me lots of time.
Thanks
This is my first post in any forum, so please be gentle.
I have a formula that references cells from other sheets within the same workbook. Its a workbook that calculates times that workers spend on a job with a unique job number over a number of days from individual workers time sheets and then converts to a cost in a single cell on another costing sheet.
Most of it I have worked out, but for every job number created, I am having to manually type in a formula which looks for the unique job number on the timesheets. I have been copy and pasting most of the formula and manually punching in the unique job number to look for.
Please see formula below:
=SUMIFS('KRIS LAB'!L:L,'KRIS LAB'!B:B,"=3424")
I have that formula in 6 adjacent columns, with only the workers name changing in each (Saul, Nick, Billy, Tom, Cameron)
How can I drag that row, but increment the numerical part only so the next row keeps everything the same but ends in 3425, and then the row after 3256 etc...?
I have tried selecting one row and when I drag, it make duplicates of the same formula with same job number. If I select 3 or 4 rows, when I drag, it repeats those same 3 or 4 job numbers over and over.
Job numbers are formatted as 'number'. Not sure if this matters, but I'm trying to give as much info as I can to aid a speedy solution if possible.
Any help would be greatly appreciated and would save me lots of time.
Thanks