• 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?

Mustang

Contractor Among Contractors
Joined
Jul 18, 2005
Messages
1,164
Likes received
1
Thanks received
1
Location
Bedfordshire
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.
 
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 :nerd
 
I hope you're not on £500+ a day...
 
Doh!!:o Blonde moment!! Thanks guys!! Sorted!! :yay:
 

Advertisers

Back
Top