John

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


Gord Dibben Excel MVP

On Fri, 31 Dec 2004 09:07:04 -0800, "John III" <John
wrote:

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.