Juco wrote:
Not quite working for me, Maybe the bit below will explain better. I need
to add up M13 M14 in M15 then either M7 or M8 M7 is a weekly rental cost
M8 is a total rental cost Some people might just fill in the weekly if
only renting for one week and leave the total blank, hence the reason i want
to pick up either or of M7 and M8. M8 if they have put the total in if not
then M7.
Hope I am not getting confusing now


Weekly rental M7
Total rental M8
Airport transfer req.
Yes or No no
Welcome pack req.
Yes or No no
Transfer cost return M13
Welcome pack M14
Total rental M15
[...]

Perhaps...

=SUM(M13:M15,IF(N(M8),M8,M7))