The formula needs to add the total of column A, from rows 1-10 to the total
of column B, from rows 1-10 and divide the total of column B by 2 before
adding to the total of column A. Something like this
=sum((a1:a10)+(b1:b10)/2).
Please help.