Formula Required

Current formula i am using:


Every time need to change the cell references


P14, W14, AD14, AK14, AR14, all refers to Weekend (Friday)

Need a short formula to sum weekend day (Friday) value (Trips) replace by (Overtime) if match. i created two named ranges Trips & Overtime

If a driver make 1 trip on friday 6 hrs OT 2 trips 8 hrs etc.

i have tried sumif sumproduct but unable to get a perfect one

By: Mohammed Ibrahim

Leave a Reply

Your email address will not be published. Required fields are marked *