+ Reply to Thread
Results 1 to 4 of 4

Is there a shortcut to addition formulas?

  1. 05-08-2007, 11:38 PM #1
    salford69
    salford69 is offline
    Registered User
    Join Date
    04-13-2007
    Posts
    5

    Is there a shortcut to addition formulas?

    I am keeping track of a dart league that requires simple addition, there is 28 players,and the league runs for 9 weeks. What I would like to know is if there is a shortcut to the formula or am I going to have to type it out in each line

    example

    Mike a1+b1+c1........j1
    Jim a2+b2+c2........j2

    and so on
    Thanks in advance
    Last edited by salford69; 05-08-2007 at 11:40 PM.
    Reply With QuoteRegister To Reply
  2. 05-08-2007, 11:53 PM #2
    alexwangsa
    alexwangsa is offline
    Registered User
    Join Date
    04-19-2007
    Location
    Sydney, AUstralia
    Posts
    25
    try this formula in cell k1 : =sum(a1:j1), in cell k2 : =sum(a2:j2) and so on
    Reply With QuoteRegister To Reply
  3. 05-09-2007, 01:05 AM #3
    salford69
    salford69 is offline
    Registered User
    Join Date
    04-13-2007
    Posts
    5
    Will give it a shot

    Thank you
    Reply With QuoteRegister To Reply
  4. 05-09-2007, 01:40 PM #4
    salford69
    salford69 is offline
    Registered User
    Join Date
    04-13-2007
    Posts
    5

    Thank you

    Quote Originally Posted by alexwangsa
    try this formula in cell k1 : =sum(a1:j1), in cell k2 : =sum(a2:j2) and so on


    Works great Thanks Alex
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1