| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
How do I use the COUNTIF formula on excel?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel
From Help:
Counts the number of cells within a range that meet the given criteria. Syntax COUNTIF(range,criteria) Range is the range of cells from which you want to count cells. Criteria is the criteria in the form of a number, expression, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", "32", "apples". =COUNTIF(A1:A100,B1) will count the number of time the value in B1 appears in A1 through A100 -- Gary's Student "babygurl" wrote: How do I use the COUNTIF formula on excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel
Debra Dalgleish has a bunch of notes for counting and summing:
http://www.contextures.com/xlFunctions04.html http://www.contextures.com/xlFunctions01.html babygurl wrote: How do I use the COUNTIF formula on excel? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Linear Mode
