Hi
This must be simple, but I can't work it out.
Can anyone suggest a formula to add into cell L3, that looks at row 3 columns F:K and if one of the cells contains a number, that number is copied into cell L3?
And then can be copied down to do the same thing for each subsequent row?
So in the below example, L3=15, L4=12
Thank you
This must be simple, but I can't work it out.
Can anyone suggest a formula to add into cell L3, that looks at row 3 columns F:K and if one of the cells contains a number, that number is copied into cell L3?
And then can be copied down to do the same thing for each subsequent row?
So in the below example, L3=15, L4=12
Thank you