Search : in
By :

Excel to count with condition

Last answer on Mar 7, 2009 12:19:54 am GMT ahgan82, on Aug 6, 2008 3:37:46 am BST 
 Report this message to moderators

Hello,
Hello,
hi genius,

urgent need help


i got set data

with

low spec =1
high spec =5


i got set data

4
5
6
7
2
4
9
0
1
4
6
8
0
3
5
7
8
9
0

how to write a formula to count how many row is less than high spec , more than low spec?

please help please help...

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « excel to count with condition » in :
[Excel] – Countif Formula Show[Excel] – Countif Formula Issue Solution Note Issue I have one excel file in that Column "B" has the "pending or Closed" Status and Column "C" has "Severity 1, Severity 2 and Severity 3" I want to count in one cell with "Pending...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
General Terms and Conditions of Use ShowAll Rights Reserved - 2009 - Communitic International Object These General Terms and Conditions are meant to define the ways in which the services of the website en.kioskea.net, hereafter "The Service," are made available, as well as the...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...

1

Zennon4, on Aug 6, 2008 1:07:43 pm BST
  • +1

Hello,

cant you find something in the help file of excel itself ?

waiting for you

Reply to Zennon4

4

 affa, on Mar 7, 2009 12:19:54 am GMT
  • +1

Di ko maintindihan

Reply to affa

2

Jack Gopher, on Aug 11, 2008 12:05:12 pm BST
  • +2

Maybe the COUNTIF function can assist you with this?

Here is a page with relevant functions tutorial videos:
http://www.free-training-tutorial.com/statistical-functions.­html

Reply to Jack Gopher

3

Rossami, on Oct 29, 2008 5:44:27 pm GMT
  • +9

If you're willing to hard-code your high and low specs, you can use this as a workaround.
=COUNT(A1:A19)-COUNTIF(A1:A19,"<=1")-COUNTIF(A1:A19,">=5")

It's counting all the instances in the range, then subtracting those values equal to or below your low spec and those equal to or above your high spec. It's clumsy but it works.

Reply to Rossami