Adsense
Popular Posts
- How to blend adsense inside your post?
- PHPWind-- A PHP forum script applcaition in China
- Password protect your folders in Windows 7 using "Folder Lock"
- Online quiz timer using JavaScript and PHP
- Install PHPMailer 5.2.4 and use smtp gmail
- PHP: add a download as pdf file button in report page
- PHP - Export Content to MS Word document
- phpexcel toggle expand and hide column in EXCEL and summary
- Solve SIR model -C++/MatLab/Python
- Bootstrap Modal Dialog Example in PHP
Thursday, March 1, 2012
EXCEL, count number of same instances
For example, in A column of EXCEL, there are 5 rows: high, high,high,high, low,low, I want to find how many high and low. In column A6, enter the following function: =COUNTIF(A1:A5,"high"), You will get the number of instance of "high" 3.
When you click fx at the top menu of EXCEL2010, you can not see COUNTIF. You only see SUM, IF, AVERAGE, HYPERLINK,COUNT......
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment