Subtract several rows from a total

This is a multi-part message in MIME format.

------=_NextPart_000_0029_01C53AC8.AD6EB0F0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Guys,

I have a total in cell C32.  I want to subtract numbers in cells C 34-40 =
and have the answer in cell C41.  I know that =3DC32-C34 will give me an =
answer but I want several rows to be subtracted.  What would my formula =
be?

I have used the insert function feature before but I don't see diff or =
anything that looks like a subtraction function in there. =20

Thanks,
Linda
------=_NextPart_000_0029_01C53AC8.AD6EB0F0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi Guys,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I have a total in cell C32.&nbsp; I want to subtract =
numbers=20
in cells C 34-40 and have the answer in cell C41.&nbsp; I know that =
=3DC32-C34=20
will give me an answer but I want several rows to be subtracted.&nbsp; =
What=20
would my formula be?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I have used the insert function feature before but I =
don't see=20
diff or anything that looks like a subtraction function in there.&nbsp;=20
</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Thanks,</FONT></DIV>
<DIV><FONT size=3D2>Linda</FONT></DIV></BODY></HTML>

------=_NextPart_000_0029_01C53AC8.AD6EB0F0--

0
LMB
4/6/2005 8:50:02 PM
excel.newusers 15348 articles. 2 followers. Follow

5 Replies
395 Views

Similar Articles

[PageSpeed] 24

This is a multi-part message in MIME format.

------=_NextPart_000_0014_01C53AF5.4CE6A670
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Linda

=3DC32-SUM(C34:C40)

Regards

Trevor

  "LMB" <RomulanQueen@10Forward.SSTNG> wrote in message =
news:eX1T1ouOFHA.524@TK2MSFTNGP09.phx.gbl...
  Hi Guys,

  I have a total in cell C32.  I want to subtract numbers in cells C =
34-40 and have the answer in cell C41.  I know that =3DC32-C34 will give =
me an answer but I want several rows to be subtracted.  What would my =
formula be?

  I have used the insert function feature before but I don't see diff or =
anything that looks like a subtraction function in there. =20

  Thanks,
  Linda
------=_NextPart_000_0014_01C53AF5.4CE6A670
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Linda</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>=3DC32-SUM(C34:C40)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Trevor</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"LMB" &lt;<A=20
  =
href=3D"mailto:RomulanQueen@10Forward.SSTNG">RomulanQueen@10Forward.SSTNG=
</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:eX1T1ouOFHA.524@TK2MSFTNGP09.phx.gbl">news:eX1T1ouOFHA.524@T=
K2MSFTNGP09.phx.gbl</A>...</DIV>
  <DIV><FONT size=3D2>Hi Guys,</FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>I have a total in cell C32.&nbsp; I want to =
subtract numbers=20
  in cells C 34-40 and have the answer in cell C41.&nbsp; I know that =
=3DC32-C34=20
  will give me an answer but I want several rows to be subtracted.&nbsp; =
What=20
  would my formula be?</FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>I have used the insert function feature before but =
I don't=20
  see diff or anything that looks like a subtraction function in =
there.&nbsp;=20
  </FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>Thanks,</FONT></DIV>
  <DIV><FONT size=3D2>Linda</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0014_01C53AF5.4CE6A670--

0
Trevor9259 (673)
4/6/2005 9:09:28 PM
Look at the SUM Worksheet Formula

C41:    =C32 - SUM(C34:Offset(C41,-1,0))

I guess C33 is on a blank row or at least that cell is empty.
The use of OFFSET(C41,-1,0)  instead of  C40
allows you to insert a row before row 41 later that
would also be subtracted.
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

"LMB" <RomulanQueen@10Forward.SSTNG> wrote in message news:eX1T1ouOFHA.524@TK2MSFTNGP09.phx.gbl...
Hi Guys,

I have a total in cell C32.  I want to subtract numbers in cells C 34-40 and have the answer in cell C41.  I know that =C32-C34 will
give me an answer but I want several rows to be subtracted.  What would my formula be?

I have used the insert function feature before but I don't see diff or anything that looks like a subtraction function in there.

Thanks,
Linda


0
dmcritchie (2586)
4/6/2005 9:14:07 PM
LMB wrote:
> Hi Guys,
>  
> I have a total in cell C32.  I want to subtract numbers in cells C 34-40 
> and have the answer in cell C41.  I know that =C32-C34 will give me an 
> answer but I want several rows to be subtracted.  What would my formula be?
>  
> I have used the insert function feature before but I don't see diff or 
> anything that looks like a subtraction function in there. 
>  
> Thanks,
> Linda
Here's one way..put this in C41

= C32-(SUM( C34:C40))
0
gls858 (460)
4/6/2005 9:16:19 PM
This is a multi-part message in MIME format.

------=_NextPart_000_0037_01C53ACC.E38FAAF0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks you guys!
  "LMB" <RomulanQueen@10Forward.SSTNG> wrote in message =
news:eX1T1ouOFHA.524@TK2MSFTNGP09.phx.gbl...
  Hi Guys,

  I have a total in cell C32.  I want to subtract numbers in cells C =
34-40 and have the answer in cell C41.  I know that =3DC32-C34 will give =
me an answer but I want several rows to be subtracted.  What would my =
formula be?

  I have used the insert function feature before but I don't see diff or =
anything that looks like a subtraction function in there. =20

  Thanks,
  Linda
------=_NextPart_000_0037_01C53ACC.E38FAAF0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Thanks you guys!</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"LMB" &lt;<A=20
  =
href=3D"mailto:RomulanQueen@10Forward.SSTNG">RomulanQueen@10Forward.SSTNG=
</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:eX1T1ouOFHA.524@TK2MSFTNGP09.phx.gbl">news:eX1T1ouOFHA.524@T=
K2MSFTNGP09.phx.gbl</A>...</DIV>
  <DIV><FONT size=3D2>Hi Guys,</FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>I have a total in cell C32.&nbsp; I want to =
subtract numbers=20
  in cells C 34-40 and have the answer in cell C41.&nbsp; I know that =
=3DC32-C34=20
  will give me an answer but I want several rows to be subtracted.&nbsp; =
What=20
  would my formula be?</FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>I have used the insert function feature before but =
I don't=20
  see diff or anything that looks like a subtraction function in =
there.&nbsp;=20
  </FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>Thanks,</FONT></DIV>
  <DIV><FONT size=3D2>Linda</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0037_01C53ACC.E38FAAF0--

0
LMB
4/6/2005 9:20:11 PM
This is a multi-part message in MIME format.

------=_NextPart_000_00DB_01C53ACE.D0BC4300
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

If you gave cell C32 the RangeName "Price", and gave the range C34:C40 =
the RangeName "Costs", then you could use

=3Dprice-SUM(costs)

Vaya con Dios,
Chuck, CABGx3


  "LMB" <RomulanQueen@10Forward.SSTNG> wrote in message =
news:eX1T1ouOFHA.524@TK2MSFTNGP09.phx.gbl...
  Hi Guys,

  I have a total in cell C32.  I want to subtract numbers in cells C =
34-40 and have the answer in cell C41.  I know that =3DC32-C34 will give =
me an answer but I want several rows to be subtracted.  What would my =
formula be?

  I have used the insert function feature before but I don't see diff or =
anything that looks like a subtraction function in there. =20

  Thanks,
  Linda

------=_NextPart_000_00DB_01C53ACE.D0BC4300
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.100" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>If you gave cell C32 the RangeName =
"Price", and=20
gave the range C34:C40 the RangeName "Costs", then you could =
use</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>=3Dprice-SUM(costs)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Vaya con Dios,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Chuck, CABGx3</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"LMB" &lt;<A=20
  =
href=3D"mailto:RomulanQueen@10Forward.SSTNG">RomulanQueen@10Forward.SSTNG=
</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:eX1T1ouOFHA.524@TK2MSFTNGP09.phx.gbl">news:eX1T1ouOFHA.524@T=
K2MSFTNGP09.phx.gbl</A>...</DIV>
  <DIV><FONT size=3D2>Hi Guys,</FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>I have a total in cell C32.&nbsp; I want to =
subtract numbers=20
  in cells C 34-40 and have the answer in cell C41.&nbsp; I know that =
=3DC32-C34=20
  will give me an answer but I want several rows to be subtracted.&nbsp; =
What=20
  would my formula be?</FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>I have used the insert function feature before but =
I don't=20
  see diff or anything that looks like a subtraction function in =
there.&nbsp;=20
  </FONT></DIV>
  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>Thanks,</FONT></DIV>
  <DIV><FONT size=3D2>Linda</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_00DB_01C53ACE.D0BC4300--

0
croberts (1377)
4/6/2005 9:33:58 PM
Reply:

Similar Artilces: