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.

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.

... Something like this
=sum((a1:a10)+(b1:b10)/2).

Frank's formula is what you want. However, just to mention...yours would
have worked if you entered it as an Array Formula

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

or slightly better...
=SUM(A1:A10,B1:B10/2) (Ctrl+Shift+Enter)

--
Dana DeLouis
Win XP & Office 2003


"John III" <John wrote in message
...
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.

Hi Dana
the following non-array should do as well :-))
=SUMPRODUCT(A1:A10+B1:B10/2)

just one more alternative...

--
Regards
Frank Kabel
Frankfurt, Germany
"Dana DeLouis" schrieb im Newsbeitrag
...
... Something like this
=sum((a1:a10)+(b1:b10)/2).

Frank's formula is what you want. However, just to mention...yours would
have worked if you entered it as an Array Formula

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

or slightly better...
=SUM(A1:A10,B1:B10/2) (Ctrl+Shift+Enter)

--
Dana DeLouis
Win XP & Office 2003


"John III" <John wrote in message
...
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.

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.