Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

To get a sum of how many times "January" shows up in the sheet, you could type a formula such as:

=COUNTIF(A1:Z9999;"January")

The first parameter of the COUNTIF() function specifies the range of cells to be searched. In this example it is assumed that your sheet does not contain any column beyond Z, nor any row beyond 9999.