1. Contracting
    1. General
      1. Brexit
    2. Business / Contracts
      1. Coronavirus Assistance
    3. Accounting / Legal
      1. Umbrella Companies
      2. HMRC Scheme Enquiries
      3. The Future of Contracting
      4. IR35 Reform
    4. Technical
    5. Welcome / FAQs
  2. Social
    1. Light Relief
    2. Social / Events
  • Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel info?

Collapse
X
1 to 6 of 6 Previous template Next
Collapse
Reply to Thread
  •  
  • Filter
  • Time
  • Show
Clear All
new posts
1 to 6 of 6 Previous template Next
    #1

    Excel info?

    I have a table of data. For each column I want to count the number of data items that goes over a certain threshold. i.e. if the threshold were 10, the following entries

    10
    9
    12
    14
    5
    20

    would yield the answer of 3

    Can anyone suggest how to do this?

    TIA.
    Tags: None
    #2
    look up COUNTIF
    McCoy: "Medical men are trained in logic."
    Spock: "Trained? Judging from you, I would have guessed it was trial and error."

    Comment

      #3
      Yes,

      If that data is in column A, then in column B put the following formular in each cell adjacent to the value in A.

      =IF(A1>10,1,0)

      Copy this equation down each row.

      Then at the botttom or top, put a sum for Column B.
      The sum will be the total number of rows that have a value > 10

      HTH
      Originally posted by cailin maith
      Hang on - there is actually a place called Cheddar??

      Comment

        #4
        Originally posted by lilelvis2000 View Post
        look up COUNTIF
        Oh yeah =COUNTIF(A1:A3,"> 10") would have done it.

        Originally posted by cailin maith
        Hang on - there is actually a place called Cheddar??

        Comment

          #5
          I hope you're not on £500+ a day...
          "Never argue with stupid people, they will drag you down to their level and beat you with experience". Mark Twain

          Comment

            #6
            Doh!! Blonde moment!! Thanks guys!! Sorted!!

            Comment

            Reply to Thread
            1 to 6 of 6 Previous template Next

            Advertisers

            1. Contracting
              1. General
                1. Brexit
              2. Business / Contracts
                1. Coronavirus Assistance
              3. Accounting / Legal
                1. Umbrella Companies
                2. HMRC Scheme Enquiries
                3. The Future of Contracting
                4. IR35 Reform
              4. Technical
              5. Welcome / FAQs
            2. Social
              1. Light Relief
              2. Social / Events
            Working...
            X