Reply to topic  [ 4 posts ] 
Getting Excel to ignore a letters in a sum? 
Author Message
Doesn't have much of a life
User avatar

Joined: Thu Apr 23, 2009 10:35 pm
Posts: 1657
Location: Ipswich
Reply with quote
Hi all, hope you can help

I have basic knowledge of Excel and use a spread sheet to organise and display results in the F1 league I run on th PS3 via RD forum.

currently I use "0" for any event apart from a score but would like to start recording and displaying the following - disqualifications (DSQ), Did not finish (DNF), Disconnect (DSC) and did not start (DNS)

When I try to enter the 3 letters I get an error in the Points column

Code is basic using SUM (example) =F3+G3+H3+I3+J3+K3+L3+M3+N3+O3+P3+Q3+R3+S3+T3+U3+V3+W3+X3

Image


Any help would be appreciated

Rich

_________________
www.youtube.com/hyperviper34


Sun May 06, 2012 10:46 am
Profile
Site Admin
User avatar

Joined: Fri Apr 24, 2009 6:12 am
Posts: 7011
Location: Wiltshire
Reply with quote
not sure if I'm understanding you correctly but surly =SUM(F3:X3) will do the job for you ? :?

_________________
<input type="pickmeup" name="coffee" value="espresso" />


Sun May 06, 2012 11:01 am
Profile WWW
Doesn't have much of a life
User avatar

Joined: Thu Apr 23, 2009 10:35 pm
Posts: 1657
Location: Ipswich
Reply with quote
AlunD wrote:
not sure if I'm understanding you correctly but surly =SUM(F3:X3) will do the job for you ? :?


Yes it does thank you, my line was way to basic by the sound of it. I'm learning slowly but as this is the only real thing I did with excel my knowledge is very limited.

Cheers Alun

_________________
www.youtube.com/hyperviper34


Sun May 06, 2012 3:59 pm
Profile
Site Admin
User avatar

Joined: Fri Apr 24, 2009 6:12 am
Posts: 7011
Location: Wiltshire
Reply with quote
your welcome

_________________
<input type="pickmeup" name="coffee" value="espresso" />


Sun May 06, 2012 4:51 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 4 posts ] 

Who is online

Users browsing this forum: No registered users and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.