Add duty numbers to get weekly wages

[BusThunder]

Sorry for this,

Attachment 223274

What I would like to achieve is that on worksheet named "297 Middle" and on column K to ADD the weekly amount £ from each row (Duty number). Using the informations from the other worksheets.

Regards,

Oscar

[jeffreybrown]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[jeffreybrown]

Hi Oscar & Welcome to the Forum,

Tried to open your attachment but it does not seem to want to cooperate. Can you reattach the attachment?

Also, thank you for changing the title...

[BusThunder]

297 Duty Roster.xls

What about this one?

[jeffreybrown]

I'm not entirely sure what you are doing so a little explanation would help...

In the meantime you can also try in K11...

=SUMIF('Daily Duty Roster'!$C$4:$U$37,MODE(D11:J11),'Daily Duty Roster'!E4:W37)*4

...but again have no idea what the times 4 means

[BusThunder]

Sugar, well spotted, it is actually *5, my bad, because that week I am doing duty 119, five days in a row (Mon-Fri) So I should be multiplying 5 times what it pays for that week.

Is there a way in excel to reference a cell value (like duty "119") in worksheet "297 Middle" and be equal to a currency on another worksheet example: E22 on Daily Duty Roster (worksheet)

[jeffreybrown]

See if this setup will help without getting into an overly complicated formula...

In column E, G, I, K, M, O, and Q added a helper column which you can hide...

Column R will now hold the sum

[BusThunder]

Excellent, thank you very much.

Another challenge solved, this time from you.

This is very useful, I don't understand the 3,0),"") on that formula, =IFERROR(VLOOKUP(D6,Table_Saturday,3,0),"")

I would be grateful if you could briefly explain this to me and I thank you again. Oh, yes, and why it has to be IFERROR??


Regards