I need help writing a formula.

[John III]

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.

 

[Frank Kabel]

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

 

[Dana DeLouis]

... 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)

 

[Frank Kabel]

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

just one more alternative...

 

[Gord Dibben]

John

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


Gord Dibben Excel MVP

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