Excel Forum
Similar Content
Sparkling Christmas Tree in Excel
Tutorial: How to make a wonderful sparkling Christmas tree in Excel. This method uses only formulas...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Count Blank Cells in Excel
Tutorial: How to count blank cells, including formulas that output a blank. Sections: Count Blank C...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 362: 12 Amazing Counting Formulas


See the functions, FREQUENCY, SUMPRODUCT, COUNTIF, COUNTA, COUNT, ISNUMBER, ROWS, COUNTDIFF, UNIQUEVALUES functions. MoreFunc Add-in
1)Count cells in range
2)Count not empty
3)Count not blank
4)Count words
5)Count numbers
6)Count unique items
7)Count duplicate items
8)Count unique numbers in a column with numbers and text
9)More
Related video: Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions





Got a Question? Ask it Here in the Forum.