Spreadsheets_CountIf

=Spreadsheets - The CountIF Function= include component="page" page="menu-Applications" editable="1" include component="page" page="menu-spreadsheets" editable="1"
 * **NUMBERS**

You've already seen how spreadsheets can process NUMERICAL functions
 * SUM** and **AVERAGE** || **TEXT**

There are other functions designed to tally up TEXT data:


 * COUNTA** and **COUNTIF** ||

Download the "COUNTIF SNACKTIME.XLS file" to your appropriate server folder

The **COUNTA(range)** function will tally up the number of pieces of text data in a desired range
 * [[image:Spreadsheets_CountA.png]] || **COUNT**A

Go to cell B18 and apply the function

NOTES
 * Only cells that contain data will be counted (Try deleting one of the "apples") ||
 * [[image:Spreadsheets_CountIF.png]] || COUNTIF

The **COUNTIF(//range, criteria//)** function will tally up the number of pieces that match the criteria


 * Criteria can be literal ("apples") but cell references (A21) are more flexible
 * Range can be defined by a range name (snacks) ||