Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Excel to count with condition

ahgan82, on Wednesday August 6, 2008 03:37:46 AM
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
Reply to ahgan82  Report this message to moderators Go to last message

1


  • This message seems useful, vote!
  • Report this message to moderators
Zennon4, on Wednesday August 6, 2008 01:07:43 PM
hello,

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

waiting for you
   
Reply to Zennon4

2


  • This message seems useful, vote!
  • Report this message to moderators
Jack Gopher, on Monday August 11, 2008 12:05:12 PM
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


  • This message seems useful, vote!
  • Report this message to moderators
 Rossami, on Wednesday October 29, 2008 05:44:27 PM
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
Ask your question Reply

Results for

Excel question - conditional format (Solved) Hello, I am trying to format excel file base on date. I have a excel file with lots rows in which a cell contains date info. I want to format it like this: If the date in the line is less than today, change the row to red; If the date is between today... en.kioskea.net/forum/affich-7133-excel-question-conditional-format
Excel COUNTIF with 2 conditions Hello, Does anyone know how to create a total using 2 conditions from COUNTIF statements. I have a worksheet that has 2 seperate countif statements ( 1.Total up the number of times "L" appears in colum J) (2.Total up the number of times "D" appears in... en.kioskea.net/forum/affich-4316-excel-countif-with-2-conditions
Count days in excel Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks Filippos en.kioskea.net/forum/affich-30759-count-days-in-excel

Results for

How to count number of words in MS Words sheet!How to count number of words in MS Words sheet! It is quite simple to count the number of words in a Microsoft word sheet. This tip might be very useful for example, if you wish to make a presentation on Microsoft word for an approximate number... en.kioskea.net/faq/sujet-354-how-to-count-number-of-words-in-ms-words-sheet
Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell
How to convert Excel into PDF?How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. PDF995 is software that gets installed on your computer which enables you to print any sources of document to PDF.... en.kioskea.net/faq/sujet-552-how-to-convert-excel-into-pdf
1 2 3 Next

Results for

Conditional Format ProblemHello, I want to use Excel Conditional Format to change color of an entire row whenever there is a "cancel" placed in any of the cells in that row. All other information involves taking a value from a column entry, and not a row entry. We have daily... en.kioskea.net/forum/affich-10118-conditional-format-problem
Conditional Formatting with expiry datesHello, I am working on a large excel spreadsheet full of training records. I have managed to use conditional formatting to highlight when a course has expired. However I am struggling to highlight when a course is due to expire within 3 months of... en.kioskea.net/forum/affich-20294-conditional-formatting-with-expiry-dates
COUNTIF questionHello, I am a novice Excel use, and I have a question about where this is even possible. I have a column of dates and I want to count the number of times a month AND year appear in a single cell. For example: A1= January 2, 2007 A2= January 14, 2007... en.kioskea.net/forum/affich-8780-countif-question
1 2 3 Next

Results for

Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer
Download ConnectCode Free Excel TrainingService Excel is an inevitable when they use Windows as Word is him. However her use is not of the most intuitive for the laymen. ConnectCode Free Excel Training is a program of study for introduction with Excel. It understands ten different... en.kioskea.net/telecharger/telecharger-568-connectcode-free-excel-training
1 2 3 Next

Results for

General Terms and Conditions of Use All Rights Reserved - 2007 - Quida 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 conditions of use of the... en.kioskea.net/ccmguide/cgu-conditions-generales.php3
Spreadsheets - The Excel Interface 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 document is called a file... en.kioskea.net/tableur/tabinterface.php3
Spreadsheets - Conditional expressions 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 offer operators that compare... en.kioskea.net/tableur/tabcond.php3
1 2 3 Next