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......

No comments:

Post a Comment