SUMIF: Returns a conditional sum across a range.ĭCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.ĭCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.ĬOUNTUNIQUE: Counts the number of unique values in a list of specified values and ranges.ĬOUNTA: Returns the number of values in a dataset.ĬOUNTBLANK: Returns the number of empty cells in a given range.ĬOUNT: Returns the number of numeric values in a dataset. To use multiple criteria, use COUNTIFS or the database functions DCOUNT or DCOUNTA.ĬOUNTIFS: Returns the count of a range depending on multiple criteria. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |