DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Formulas for Counting the Number of Bold Cells in a Range In Excel!!

Excel Formulas for Counting the Number of Bold Cells in a Range:

Here we will show the information on the Formulas for Counting the Number of Bold Cells in a Range In Excel Office 365. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formula Syntax:

  • To count the number of Bold cells from a range in Excel Office, use the below formula.

=COUNTBYFONTBOLD(A1:B10)

Example:

  • For example, if you have a data range as below, do the below steps.
  • You need to enter the given formula in the selected area.
  • After applying the formula, it will display the result as shown below.

Result

Syntax Explanation:

  • COUNTBYFONTBOLD – The main purpose of this function is to count the numbers of bold cells. This function is available on Kutools in Excel Office 365.

Summary:

From this article, you will learn the formulas for counting the number of Bold cells in a range in Excel Office 365. If you have any suggestions, feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!!

Related Articles:

Top comments (0)