| A | B |
|---|
| COUNT | Returns the number of cells that contain a numeric value |
| COUNTA | Returns the number of nonblank cells |
| COUNTBLANK | Returns the number of blank cells |
| COUNTIF | Returns the number of cells that meet a specified criterion |
| COUNTIFS | Returns the number of cells that meet multiple criteria |
| SUM | Returns the sum of its arguments |
| SUMIF | Returns the sum of cells that meet a specifried criterion |
| SUMIFS | Returns the sum of cells that meet multiple criteria |
| COUNTIF(Data, 12) | Returns the number of cells containing the value 12 |
| COUNTIF(Data, "<0") | Returns the number of cells containing a negative value |
| COUNTIF(Data,"<>0") | Returns the number of cells not equal to 0 |
