Hi
=SUM(A1:A10)+SUM(B1:B10)/2

--
Regards
Frank Kabel
Frankfurt, Germany
"John III" <John schrieb im Newsbeitrag
...
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.