Close

Results 1 to 7 of 7
  1. #1
    DF VIP Member Fear345's Avatar
    Join Date
    May 2002
    Location
    entebbe
    Posts
    3,178
    Thanks
    180
    Thanked:        436
    Karma Level
    551

    Question Excel help please

    This is probably pretty easy for 99% of you but I don't use excel much.

    What i need to do is place a X in a cell and at the end of the columns give a percentage of how many X's have been placed, if that makes sense.
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

  2. #2
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,017
    Thanks
    1,150
    Thanked:        836
    Karma Level
    336

    Default Re: Excel help please

    =COUNTIF(A1:A10,"X")/(COUNTA(A1:A10)+COUNTBLANK(A1:A10))*100

    Thanks to akimba

    Fear345 (28th April 2015) 


  3. #3
    DF VIP Member Fear345's Avatar
    Join Date
    May 2002
    Location
    entebbe
    Posts
    3,178
    Thanks
    180
    Thanked:        436
    Karma Level
    551

    Default Re: Excel help please

    OK so in my spreadsheet the cell range i want to perform that calculation is on row 6 columns B to BI.

    I put this in =COUNTIF(B6:BI16,"X")/(COUNTA(B6:BI16)+COUNTBLANK(B6:BI16))*100 and after putting a x in every cell it came back with 9.09091

    Why didn't it come back with 100? what did i do wrong?
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

  4. #4
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,017
    Thanks
    1,150
    Thanked:        836
    Karma Level
    336

    Default Re: Excel help please

    B6:BI16 you not looking at 1 row but 10 rows 6-16 so it is dividing by 10

    =COUNTIF(B6:BI6,"X")/(COUNTA(B6:BI6)+COUNTBLANK(B6:BI6))*100

  5. #5
    DF VIP Member Fear345's Avatar
    Join Date
    May 2002
    Location
    entebbe
    Posts
    3,178
    Thanks
    180
    Thanked:        436
    Karma Level
    551

    Default Re: Excel help please

    Cheers m8 god knows where the 16 came from lol.

    Is there a way of rounding it up to the nearest whole number instead of seeing 21.875 for example?
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

  6. #6
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,017
    Thanks
    1,150
    Thanked:        836
    Karma Level
    336

    Default Re: Excel help please

    Format the Cell to a Number with zero decimal places?

    Thanks to akimba

    Fear345 (28th April 2015) 


  7. #7
    DF VIP Member Fear345's Avatar
    Join Date
    May 2002
    Location
    entebbe
    Posts
    3,178
    Thanks
    180
    Thanked:        436
    Karma Level
    551

    Default Re: Excel help please

    Superb m8 thanks a lot that worked perfect.
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

Similar Threads

  1. [REQUEST] Excel help
    By Fear345 in forum PC Software
    Replies: 7
    Last Post: 19th August 2017, 10:25 PM
  2. Excel help
    By BigBrand in forum PC Software
    Replies: 8
    Last Post: 28th April 2015, 11:03 AM
  3. Excel Help
    By Conkers in forum PC Software
    Replies: 2
    Last Post: 9th February 2010, 09:57 AM
  4. MS Excel Help
    By ss30 in forum PC Software
    Replies: 2
    Last Post: 2nd January 2007, 12:10 PM

Social Networking 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
  •