DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Formulas to Sum Bold Values or Numbers Only ~ Simple Method!!

Excel Formulas to Sum Bold Values or Numbers Only:

In this article, we will guide you to learn the Formulas to Sum the Bold Values or Numbers only 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:

  • Use the below formula to Sum the bold values or numbers in Excel Office.

=SUMBYFONTBOLD(A1:D9)

Example:

  • In the below image, we will show how to sum the bold value in Excel.
  • If you have the input ranges as below, enter the given formula in the selected formula bar.
  • After applying the formula, you will get the results as shown below.

Result

Syntax Explanations:

  • SUMBYFONTBOLD – This function will help to count the Bold values from your input and gives the result as a sum of the bold values.

Bottom Line:

In this article, you can get to know the formula to sum the bold values or numbers only in Excel Office 365. If you have any queries, leave it in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!!

Read Ahead:

Top comments (0)