DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Count the Number of Bold Cells in a Range in Excel Office 365!!

Count the Number of Bold Cells in a Range in Excel:

In this tutorial, we will guide you to learn the steps to Count the Number of Bold Cells in a Range in Excel Office 365 using Kutools. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Steps to Count the Number of Bold Cells in a Range:

To count only the number of bold cells in a range, do as below instructions.

  • If you have a data range like the below example image and you need to find the total count of the number of bold cells from the range, do as follows.

Example data range
Example data range

  • You need to select a blank cell to display the result.
  • On the Kutools Tab , select the Kutools Functions option, choose the Statistical & Math option, and choose the COUNTBYFONTBOLD option from the menu.

Choose COUNTBYFONTBOLD option
Choose COUNTBYFONTBOLD option

  • It will open the Function Arguments dialog box.
  • You need to click the button given in the Reference box and select the input range.

Function Arguments dialog box
Function Arguments dialog box

  • Then, hit the OK button to get the result as shown in the below screenshot.

Result
Result

Summary:

In this article, you can clearly understand the steps to Count the Number of Bold Cells in a Range in Office 365 using Kutools ** with an example. Leave your **feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

Top comments (0)