Excel Help - FMVperformance.com : The site for all your Ford Mazda and Volvo needs
Reply
 
LinkBack Thread Tools
post #1 of 13 (permalink) Old 04-30-2010, 08:04 PM Thread Starter
F1 Driver
 
Join Date: Jul 2006
Location: Allentown Pa
Posts: 7,643
Excel Help

Can some one explain to my why (b23) =b2+b2+b3+b4+b5+b6 isn't giving me the correct sum?

Rally White 2005 Mazda3 S - Lentech street terminator, Trubendz, AWR, VTCS, Apexcone 5000k lows, Alpine HD137BT stereo, Alpine FRP and MRP 450 amps, 5 farad cap, 12" Type-r @ 2Ω, Infinity Kappas 5x7.

Super Black 2004 Murano SL - Luxury Package bone stock
3driverPa is offline  
Sponsored Links
Advertisement
 
post #2 of 13 (permalink) Old 04-30-2010, 08:09 PM
F1 Driver
 
fatabbot's Avatar
 
Join Date: Dec 2062
Location: Suburbia, Texas
Posts: 17,662
Re: Excel Help

Did you mean to have B2 in there twice?
fatabbot is offline  
post #3 of 13 (permalink) Old 04-30-2010, 08:18 PM Thread Starter
F1 Driver
 
Join Date: Jul 2006
Location: Allentown Pa
Posts: 7,643
Re: Excel Help

lol no, and its correct on the spread sheet. just a typo.

Rally White 2005 Mazda3 S - Lentech street terminator, Trubendz, AWR, VTCS, Apexcone 5000k lows, Alpine HD137BT stereo, Alpine FRP and MRP 450 amps, 5 farad cap, 12" Type-r @ 2Ω, Infinity Kappas 5x7.

Super Black 2004 Murano SL - Luxury Package bone stock
3driverPa is offline  
post #4 of 13 (permalink) Old 04-30-2010, 08:28 PM
F1 Driver
 
fatabbot's Avatar
 
Join Date: Dec 2062
Location: Suburbia, Texas
Posts: 17,662
Re: Excel Help

Can you attach the spreadsheet? Impossible to diagnose without seeing it.
fatabbot is offline  
post #5 of 13 (permalink) Old 04-30-2010, 08:38 PM
Senior Member
 
john_in_the_lbc's Avatar
 
Join Date: Apr 2006
Location: Long Beach, California
Posts: 31,080
Re: Excel Help

yeah, or screenshot the formula
and check the cell types

2006 Whitewater Pearl Mazda 3 S GT Hatch: Garage Vary Valiant Lip, Grill and Eyelids : Custom JL/Alpine Audio : MazdaSpeed Accessory Springs and Swaybars : JDM MazdaSpeed Strut Bar : Koni Yellows : 5Zigen Pro Racer zr520 : Continental ExtremeContact DW : Buddy Club Condenser : XE Pedals : Black Rays Lugs : HP Tint : Stubby :
My car thread
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
john_in_the_lbc is offline  
post #6 of 13 (permalink) Old 05-03-2010, 08:03 AM
F1 Driver
 
siscim23's Avatar
 
Join Date: Apr 2007
Location: Miami, FL
Posts: 40,015
Send a message via AIM to siscim23
Re: Excel Help

Try typing (b23)=sum(b2,b3,b4,b5,b6)


What you typed should work but this is another way.



siscim23 is offline  
post #7 of 13 (permalink) Old 05-03-2010, 08:25 AM Thread Starter
F1 Driver
 
Join Date: Jul 2006
Location: Allentown Pa
Posts: 7,643
Re: Excel Help

Ill try that^

Rally White 2005 Mazda3 S - Lentech street terminator, Trubendz, AWR, VTCS, Apexcone 5000k lows, Alpine HD137BT stereo, Alpine FRP and MRP 450 amps, 5 farad cap, 12" Type-r @ 2Ω, Infinity Kappas 5x7.

Super Black 2004 Murano SL - Luxury Package bone stock
3driverPa is offline  
post #8 of 13 (permalink) Old 05-03-2010, 08:34 AM Thread Starter
F1 Driver
 
Join Date: Jul 2006
Location: Allentown Pa
Posts: 7,643
Re: Excel Help

That worked.

Rally White 2005 Mazda3 S - Lentech street terminator, Trubendz, AWR, VTCS, Apexcone 5000k lows, Alpine HD137BT stereo, Alpine FRP and MRP 450 amps, 5 farad cap, 12" Type-r @ 2Ω, Infinity Kappas 5x7.

Super Black 2004 Murano SL - Luxury Package bone stock
3driverPa is offline  
post #9 of 13 (permalink) Old 05-03-2010, 09:01 AM
F1 Driver
 
fatabbot's Avatar
 
Join Date: Dec 2062
Location: Suburbia, Texas
Posts: 17,662
Re: Excel Help

[quote author=siscim23 link=topic=171840.msg3642856#msg3642856 date=1272888196]
Try typing (b23)=sum(b2,b3,b4,b5,b6)


What you typed should work but this is another way.
[/quote]

Or....save some keystrokes and do sum(b2:b6)
fatabbot is offline  
post #10 of 13 (permalink) Old 05-03-2010, 09:25 AM
F1 Driver
 
siscim23's Avatar
 
Join Date: Apr 2007
Location: Miami, FL
Posts: 40,015
Send a message via AIM to siscim23
Re: Excel Help

Or save more keystrokes and type =sum( then click and highlight the required cells, then type )



siscim23 is offline  
Sponsored Links
Advertisement
 
Reply

  FMVperformance.com : The site for all your Ford Mazda and Volvo needs > Misc > Lounge

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the FMVperformance.com : The site for all your Ford Mazda and Volvo needs forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Posting Rules  
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

 
For the best viewing experience please update your browser to Google Chrome