Excel Spreadsheet question

Thread Tools
 
Search this Thread
 
Old Oct 24, 2008 | 02:57 PM
  #1  
PatriotT/A's Avatar
Thread Starter
On The Tree
 
Joined: Oct 2004
Posts: 162
Likes: 0
From: Arlington, TX
Default Excel Spreadsheet question

It's been eternity since I used Excel and all I need to know is how to multiply everything in column A times column B to equal coulmn C.
Reply
Old Oct 24, 2008 | 03:02 PM
  #2  
Sales2@Texas-speed's Avatar
LS1Tech Premium Sponsor
iTrader: (5)
 
Joined: Jan 2008
Posts: 5,053
Likes: 7
From: Texas!
Default

In the cell you want the product to be, make this the command in the box near the top...this would multiply cells c1 through f1 by each other.

=C1*D1*E1*F1

To the best of my knowledge, you cannot multiply columns by each other....you have to sum columns, and then multiply, or take the product of a column times the product of another, etc. Have a screen shot of what you're trying to do? That might help make it easier for us to help you!
__________________


Largest Stocking Distributor of LS-x Engines / CHECK OUT OUR NEW WEBSITE!

COMP - FAST - PACESETTER - DIAMOND RACING - EAGLE SPECIALTY PRODUCTS - CALLIES - COMETIC GASKETS
RAM CLUTCHES - MOSER ENGINEERING - KOOK'S HEADERS - ARP - GM BOLTS AND GASKETS - MSD - NGK
POWERBOND - ASP - AND MORE!
Reply
Old Oct 24, 2008 | 03:16 PM
  #3  
Morbid's Avatar
12 Second Club
iTrader: (34)
 
Joined: Dec 2003
Posts: 1,383
Likes: 1
From: The Colony, TX
Default

How many places did you post this? Like said in the other thread, Excel does have a Help feature.
Reply
Old Oct 24, 2008 | 03:20 PM
  #4  
Sales2@Texas-speed's Avatar
LS1Tech Premium Sponsor
iTrader: (5)
 
Joined: Jan 2008
Posts: 5,053
Likes: 7
From: Texas!
Default

I all the way down you just want A1xB1=C1, a2xb2=c2, etc...just type what I did in the first field with the correct column and row info, click tab or whatever to get off that cell, and then highlight it again. Now control C or right click and copy. go to the next cell down, paste...down, paste...down paste. Excel will adjust the numbers for the row you're on.

Does that help any?
__________________


Largest Stocking Distributor of LS-x Engines / CHECK OUT OUR NEW WEBSITE!

COMP - FAST - PACESETTER - DIAMOND RACING - EAGLE SPECIALTY PRODUCTS - CALLIES - COMETIC GASKETS
RAM CLUTCHES - MOSER ENGINEERING - KOOK'S HEADERS - ARP - GM BOLTS AND GASKETS - MSD - NGK
POWERBOND - ASP - AND MORE!
Reply
Old Oct 24, 2008 | 03:23 PM
  #5  
Elite_Hot_Rod's Avatar
TECH Addict
 
Joined: Feb 2002
Posts: 2,319
Likes: 0
From: Lewisville, Texas
Default

In column C type the following =(acell#*bcell#) looks like this =(a1*b1).
Reply
Old Oct 24, 2008 | 03:48 PM
  #6  
Greed4Speed's Avatar
TECH Enthusiast
iTrader: (7)
 
Joined: Sep 2003
Posts: 600
Likes: 0
From: Ft. Worth-ish
Default

Or just use the formula wizard for product.
Reply
Old Oct 24, 2008 | 04:03 PM
  #7  
PatriotT/A's Avatar
Thread Starter
On The Tree
 
Joined: Oct 2004
Posts: 162
Likes: 0
From: Arlington, TX
Default

Originally Posted by Morbid
How many places did you post this? Like said in the other thread, Excel does have a Help feature.
Dang man...any particular reason why you see it necessary to talk **** about my Excel Skills? Being that I don't use Excel ever, why would I know that there's a feature that helps with formulas? I posted it in the Texas area b/c it usually provides the quickest response, and in the Racer's Lounge just in case someone would reply faster. I got adequate help and a little crap talked in both entries. Guess I just don't get the cubicle humor.

EDIT: I would like to thank everyone else for the help.

Last edited by PatriotT/A; Oct 24, 2008 at 04:06 PM. Reason: Thanks to everyone else for the help.
Reply
Old Oct 25, 2008 | 11:23 PM
  #8  
1badassz's Avatar
Teching In
iTrader: (4)
 
Joined: Sep 2004
Posts: 33
Likes: 0
From: N. Dallas/Plano
Default

If Column A = Rows 1 -10
And Column B = Rows 1 -10
And Column C = Rows 1 -10
Then =SUM(A1:A10)*SUM(B1:B10)*SUM(C1:C10)
Reply
LS1 Tech Stories

The Best V8 Stories One Small Block at Time

story-0

6 Gifts Neither Your Dad Nor Grad Will Shove Into the 'Trinket Drawer'

 Brett Foote
story-1

Topdon ONE vs. Artidiag 800 BT2: Which is the Diagnostic Tablet For You?

 Pouria Savadkouei
story-2

Gas Monkey Built a 6-Wheel Ferrari Testarossa With a Corvette LT4 Engine

 Verdad Gallardo
story-3

7 Most Reliable High-Performance Engines GM Has Ever Built

 Verdad Gallardo
story-4

Amazing '71 Camaro Restomod Is Modern Muscle Car Under the Skin

 Verdad Gallardo
story-5

6 Common C5 Corvette Failures and What's Involved In Repairing Them

 Pouria Savadkouei
story-6

Retro Modern Bandit Pontiac Trans AM Comes With Burt Reynolds' Autograph

 Verdad Gallardo
story-7

Top 10 Greatest Cadillac V Series Performance Models Ever, Ranked

 Pouria Savadkouei
story-8

Top 10 Most Powerful Chevy Trucks Ever Made!

 
story-9

Hennessey's New Supercharged Silverado ZR2 Has 700 HP

 Verdad Gallardo




All times are GMT -5. The time now is 10:12 AM.

story-0
6 Gifts Neither Your Dad Nor Grad Will Shove Into the 'Trinket Drawer'

Don't get dad new socks or a grill brush this year.

By Brett Foote | 2026-06-09 14:55:56


VIEW MORE
story-1
Topdon ONE vs. Artidiag 800 BT2: Which is the Diagnostic Tablet For You?

Slideshow: We take a close look at the ONE and Artidiag 800BT2 diagnostic tools from Topdon and the reasons to buy one over the other.

By Pouria Savadkouei | 2026-05-28 11:05:11


VIEW MORE
story-2
Gas Monkey Built a 6-Wheel Ferrari Testarossa With a Corvette LT4 Engine

Slideshow: The controversial Ferrari F6 swaps its original flat-12 for a Corvette Z06-derived LT4 V8 and sends power to four rear wheels through a custom-built drivetrain.

By Verdad Gallardo | 2026-05-26 18:23:54


VIEW MORE
story-3
7 Most Reliable High-Performance Engines GM Has Ever Built

Slideshow:These GM engines didn't just make huge power, they survived abuse, boost, track days, and six-digit mileage with a reputation for refusing to quit.

By Verdad Gallardo | 2026-05-21 16:45:27


VIEW MORE
story-4
Amazing '71 Camaro Restomod Is Modern Muscle Car Under the Skin

Slideshow: This heavily modified 1971 Camaro mixes classic muscle car styling with a fifth-generation Camaro interior and modern LS3 power.

By Verdad Gallardo | 2026-05-12 18:06:42


VIEW MORE
story-5
6 Common C5 Corvette Failures and What's Involved In Repairing Them

Slideshow: From wobbling harmonic balancers to failed EBCMs, these are the issues that define long-term C5 ownership and what repairs typically involve.

By Pouria Savadkouei | 2026-05-07 18:44:57


VIEW MORE
story-6
Retro Modern Bandit Pontiac Trans AM Comes With Burt Reynolds' Autograph

Slideshow: A modern Camaro transformed into a retro icon, this limited-run "Bandit" build blends nostalgia with brute force in a way few revivals manage.

By Verdad Gallardo | 2026-04-21 13:57:02


VIEW MORE
story-7
Top 10 Greatest Cadillac V Series Performance Models Ever, Ranked

Slideshow: Cadillac didn't just crash the high-performance luxury vehicle party, it showed up loud, supercharged, and occasionally a little unhinged...

By Pouria Savadkouei | 2026-04-16 10:05:15


VIEW MORE
story-8
Top 10 Most Powerful Chevy Trucks Ever Made!

Slideshow: Top ten most powerful Chevy trucks ever made

By | 2026-03-25 09:22:26


VIEW MORE
story-9
Hennessey's New Supercharged Silverado ZR2 Has 700 HP

Slideshow: Hennessey has turned the Silverado ZR2 into a 700-hp off-road monster with supercharged V8 power and a limited production run.

By Verdad Gallardo | 2026-03-24 18:57:52


VIEW MORE