#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default sums

Ok I have a weight in column D4 and a quantity of that item weight in A4 that
I want the total weight in column E4 how do i get this

then I have an item price in column F4 and a quantity amount in A4 that I
want the total cost in column G4 how do i get this. can any one please help
me I have been trying this all day with no success and its driveing me crazy
can any one help me be able to accomplish this PLEASE
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 419
Default sums

KELLEE,

In cell E4, use this formula:

=D4*A4

In cell G4, use this formula"

=F4*A4

HTH,

Conan




"KELLEE" wrote in message
...
Ok I have a weight in column D4 and a quantity of that item weight in A4
that
I want the total weight in column E4 how do i get this

then I have an item price in column F4 and a quantity amount in A4 that I
want the total cost in column G4 how do i get this. can any one please
help
me I have been trying this all day with no success and its driveing me
crazy
can any one help me be able to accomplish this PLEASE



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default sums

In E4 enter =D4*A4

In G4 enter =F4*A4

For new users I post this information..........

Here are a few basic tutorials for Excel to get a beginner going.

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx


Gord Dibben MS Excel MVP

On Thu, 7 Feb 2008 13:40:00 -0800, KELLEE
wrote:

Ok I have a weight in column D4 and a quantity of that item weight in A4 that
I want the total weight in column E4 how do i get this

then I have an item price in column F4 and a quantity amount in A4 that I
want the total cost in column G4 how do i get this. can any one please help
me I have been trying this all day with no success and its driveing me crazy
can any one help me be able to accomplish this PLEASE


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,311
Default sums

In E4:
=D4*A4

In G4:
=F4*A4

HTH,
Paul

--

"KELLEE" wrote in message
...
Ok I have a weight in column D4 and a quantity of that item weight in A4
that
I want the total weight in column E4 how do i get this

then I have an item price in column F4 and a quantity amount in A4 that I
want the total cost in column G4 how do i get this. can any one please
help
me I have been trying this all day with no success and its driveing me
crazy
can any one help me be able to accomplish this PLEASE



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default sums

In E4 put the formula =A4*D4 to get the total weight. In G4 put the formula
=A4*F4 to get the total cost
Tyro

"KELLEE" wrote in message
...
Ok I have a weight in column D4 and a quantity of that item weight in A4
that
I want the total weight in column E4 how do i get this

then I have an item price in column F4 and a quantity amount in A4 that I
want the total cost in column G4 how do i get this. can any one please
help
me I have been trying this all day with no success and its driveing me
crazy
can any one help me be able to accomplish this PLEASE



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMS Pascale Excel Discussion (Misc queries) 2 January 9th 08 07:55 PM
How to add previous sums in a column to current sums in a column? TD Excel Worksheet Functions 1 September 30th 06 02:55 PM
Sums madmam Excel Discussion (Misc queries) 2 July 27th 06 04:56 PM
Sums cosmos5955 Excel Discussion (Misc queries) 1 March 30th 06 09:42 PM
Sums Jet Excel Discussion (Misc queries) 5 January 13th 05 06:51 PM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"