excel spreadsheet help

[Guest]

I need to get a final "total" for column h subtracting column g, f, and e from d

 

[Norman Harker]

Hi tmallow!

Do you want:
=D1-SUM(E1:F1)


Or:
=SUM(D)-SUM(E:G)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave R.]

I need a fast car, a giant house, a hot woman, a fat wallet and a giant
steak.

How about SUM(H1:100)-SUM(G1:F100)

I am not sure what to do with the "and e from d" part, feel free to clarify,
or maybe someone else knows what you mean.

I need to get a final "total" for column h subtracting column g, f, and e

from d

 

[Guest]

it seems you have the right idea of what i need....do i choose a function

----- Norman Harker wrote: ----

Hi tmallow

Do you want
=D1-SUM(E1:F1


Or
=SUM(D)-SUM(E:G
--
Regard
Norman Harker MVP (Excel
Sydney, Australi
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments
available free to good homes

 

[Norman Harker]

Hi!

Re: do i choose a function?

??

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

im speaking of columns.....column d is my subtotal now i need to subtract column g, column e, column f to give me my "total" in row h

----- Dave R. wrote: -----

I need a fast car, a giant house, a hot woman, a fat wallet and a giant
steak.

How about SUM(H1:100)-SUM(G1:F100)

I am not sure what to do with the "and e from d" part, feel free to clarify,
or maybe someone else knows what you mean.

I need to get a final "total" for column h subtracting column g, f, and e

from d