Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel and Google site.
Adsense
Popular Posts
- PHPWind-- A PHP forum script applcaition in China
- Free host forum is not reliable
- Formatting my post
- Powerful js library datable to export table in pdf, excel, sorting, freezing column and table header fixed (sticky)
- job interview questions (1)
- Set up a child account and set screen time limit in Windows 8
- PHP: add a download as pdf file button in report page
- phpexcel toggle expand and hide column in EXCEL and summary
- WinMerge - file and folder differencing and merging tool for Windows
- PHP connect IBM db2 database in XAMPP
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