+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Help with a specific Excel query in Technical; Hello Everyone First of all this is a personal request so I'm sorry if this should have gone somewhere else. ...
  1. #1

    Join Date
    Jul 2009
    Location
    Birmingham
    Posts
    80
    Thank Post
    11
    Thanked 7 Times in 6 Posts
    Rep Power
    12

    Help with a specific Excel query

    Hello Everyone

    First of all this is a personal request so I'm sorry if this should have gone somewhere else.

    I will try to explain the best I can but I am useless with Excel.

    Myself and a few friends are doing a pool league and I am trying to create a spreadsheet to calculate games played, games won, games lost, balls potted for, balls potted against and points.

    The idea, is when someone has finished their game, they can input the results and it totals them up as they go along, then at the end of the night all the information is already there to compile the league table.

    untitled.JPG

    This is what it looks like so far. I'm struggling to work out how to calculate Games Played, Games won, Games Lost and Points. I have tried playing with the IF function but its like I'm banging my head against a brick wall

    I would love it if anyone could point me in the right direction

  2. #2

    Join Date
    Jul 2009
    Location
    Birmingham
    Posts
    80
    Thank Post
    11
    Thanked 7 Times in 6 Posts
    Rep Power
    12
    Found out how to do it, but I have another question.

    Does anyone know of any setting in Excel you can configure so that if a cell is blank, any calculation on that cell are ignored?

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] Help with Excel Macro - Send email based on cell value.
    By Svarcy in forum Office Software
    Replies: 1
    Last Post: 14th June 2011, 08:02 AM
  2. Help with Excel Chart
    By TechSupp in forum General Chat
    Replies: 3
    Last Post: 9th November 2009, 12:19 PM
  3. Help With SQL Query Error
    By penfold_99 in forum Coding
    Replies: 6
    Last Post: 15th May 2009, 01:30 PM
  4. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 04:19 PM
  5. help with excel macro needed
    By oyoung in forum Windows
    Replies: 0
    Last Post: 30th March 2007, 10:27 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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