Quote Originally Posted by incidentals View Post
there are anumber of ways to attack this problem, but they all need a little more information than you have given...

for a start why do you curtail the row to just this range what is outwith the range?

why are you looping through the rows or have i missed somethig here?

i think i got the idea that you want to do a block from f to k fro row 1 to 6 for example?

here to help
You got it. I have a worksheet where the crew leader for the day adds the list of jobs that crew did, one to each row, then lists the crew members that participated in that particular job horizontally, starting in column F and moving right. There could be anywhere from 1 to 8 or 9 crew members on a particular job.

Instead of having the crew leader type in manually how many people were on the jobsite, THEN list them all out, I simply wanted to calculate how many people were on a particular jobsite based on how many names were entered in from Column F on through Column K (for the current row) or however many I need to contain all the names.

After calculating pay for the current row, I add one to the row counter and loop through again, adding up each crew member's pay for the whole week for all jobs put together.

Our crew members are paid based on a percentage of the overall job amount; that percentage changes depending on how many people were working on the job.

You were on the right track, yes.