excel spreadsheet help

  • Thread starter Thread starter Guest
  • Start date Start date
Hi tmallow!

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


Or:
=SUM(D: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.
 
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.


tmallow said:
I need to get a final "total" for column h subtracting column g, f, and e
Click to expand...
from d
 
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: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
 
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.
 
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.


tmallow said:
I need to get a final "total" for column h subtracting column g, f, and e
Click to expand...
from d
 
Back
Top