### Counting Functions

#### Worksheet Functions

COUNT | Returns the number of non blank cells in a list, table or cell range. |

COUNTA | Returns the number of non blank cells in a list, table or cell range (including logical values and text). |

COUNTBLANK | Returns the number of blank cells in a list, table or cell range. |

COUNTIF | Returns the number of non blank cells that satisfies one condition. You can achieve the same results by combining the SUM function with array formulas. |

COUNTIFS | Returns the number of non blank cells that satisfies multiple conditions. |

DCOUNT | Returns the total number of non blank cells in a database column satisfying certain conditions. |

AGGREGATE | Returns the aggregate of values in a list, table or cell range. This function is useful when you need to get the count of rows that have been filtered using the AutoFilter. |

SUBTOTAL | Returns the subtotal of values in a list, table or cell range. |

SUMPRODUCT | Returns the sum of the product of one or more arrays of values. |

COUNTReturns the number of non blank cells in a list, table or cell range. |

COUNTAReturns the number of non blank cells in a list, table or cell range (including logical values and text). |

COUNTBLANKReturns the number of blank cells in a list, table or cell range. |

COUNTIFReturns the number of non blank cells that satisfies one condition. You can achieve the same results by combining the SUM function with array formulas. |

COUNTIFSReturns the number of non blank cells that satisfies multiple conditions. |

DCOUNTReturns the total number of non blank cells in a database column satisfying certain conditions. |

AGGREGATEReturns the aggregate of values in a list, table or cell range. This function is useful when you need to get the count of rows that have been filtered using the AutoFilter. |

SUBTOTALReturns the subtotal of values in a list, table or cell range. |

SUMPRODUCTReturns the sum of the product of one or more arrays of values. |

#### Conditional Counting

COUNTIF | Using the COUNTIF function with multiple conditions. |

COUNTIFS | Using the COUNTIFS function with multiple conditions. |

SUMPRODUCT | Using the SUMPRODUCT function with multiple conditions. |

COUNTIFUsing the COUNTIF function with multiple conditions. |

COUNTIFSUsing the COUNTIFS function with multiple conditions. |

SUMPRODUCTUsing the SUMPRODUCT function with multiple conditions. |

#### User Defined Functions

COUNTVISIBLE | Returns the number of visible non blank cells. |

COUNTIFVISIBLE | Returns the number of visible non blank cells that satisfies one condition. |

COUNTIFSVISIBLE | Returns the number of visible non blank cells that satisfies multiple conditions. |

COUNTFORMAT | Returns the number of cells that have been formatted with multiple attributes. |

COUNTFORMAT_FONTBOLD | Returns the number of cells that have been formatted in bold. |

COUNTFORMAT_FONTCOLOR | Returns the number of cells that have been formatted with a particular font colour. |

COUNTFORMAT_CELLCOLOR | Returns the number of cells that have been formatted with a particular colour. |

COUNTNUMBEROFDAYS | Returns the number of days in a specific month and/or year. |

COUNTTEXTCELLS | Returns the number of cells that contain text. |

COUNTSUBSTRING | Returns the number of |

COUNTVISIBLEReturns the number of visible non blank cells. |

COUNTIFVISIBLEReturns the number of visible non blank cells that satisfies one condition. |

COUNTIFSVISIBLEReturns the number of visible non blank cells that satisfies multiple conditions. |

COUNTFORMATReturns the number of cells that have been formatted with multiple attributes. |

COUNTFORMAT_FONTBOLDReturns the number of cells that have been formatted in bold. |

COUNTFORMAT_FONTCOLORReturns the number of cells that have been formatted with a particular font colour. |

COUNTFORMAT_CELLCOLORReturns the number of cells that have been formatted with a particular colour. |

COUNTNUMBEROFDAYSReturns the number of days in a specific month and/or year. |

COUNTTEXTCELLSReturns the number of cells that contain text. |

COUNTSUBSTRINGReturns the number of |

#### More Counting Formulas

__Counting Formulas__ contains a list of all counting relating formulas.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext