Rey asked in Computers & InternetSoftware · 1 month ago

In Microsoft Excel Spreadsheet, what is the function of using Count (range)?

* It produces the total amount from the range of numeric cells specified.

* It helps to get the maximum of the range without an extra steps of sorting.

* It checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

* It count the number of cells in the range is not limited to numeric values.

3 Answers

Relevance
  • JASON
    Lv 6
    4 weeks ago

    The last. The first answer looks like SUM. The second is MAX. The third probably SUMPRODUCT. The last COUNT.

  • Lv 7
    1 month ago

    if you know, why are you asking?

  • 1 month ago

    The last one is the only answer which mentions counting.  The others make zero sense.  It also happens to be correct.  It COUNTS the number of cells in the range.

Still have questions? Get your answers by asking now.