Excel info? - Contractor UK Bulletin Board

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!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Mustang replied

8 April 2009, 11:28
Doh!! Blonde moment!! Thanks guys!! Sorted!!
Leave a comment:
scooterscot replied

8 April 2009, 11:17
I hope you're not on £500+ a day...
Leave a comment:
FSM with Cheddar replied

8 April 2009, 10:53
Originally posted by lilelvis2000 View Post

look up COUNTIF

Oh yeah =COUNTIF(A1:A3,"> 10") would have done it.
Leave a comment:
FSM with Cheddar replied

8 April 2009, 10:51
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
Leave a comment:
lilelvis2000 replied

8 April 2009, 10:50
look up COUNTIF
Leave a comment:
Mustang started a topic Excel info?

8 April 2009, 10:36
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

Working...

X