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