| Home > Forum Home > Automating Data Analysis Tasks > Adding up interchanging word > The COUNTIF function | Share |
The COUNTIF function
Excel Help for The Countif Function in Automating Data Analysis Tasks
| Forum Topic | Login |
The Countif Function | Rate this: (3/5 from 1 vote) |
 | To count how many times a word appears in the column (such as "RUN" in your case) you can use the COUNTIF function which takes he form of: =COUNTIF(Cell range to count, text criteria) You may also want to look at the SUMIF funtion which will total the values in another column that have the same row criteria as "RUN" or "OFF". This simply takes and extra parameter at the end which is the columns to range to sum. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for The COUNTIF function in the Excel Business Solutions Directory |