COUNTIF() function cannot be used to check the background color, foreground color, or any other formatting in Excel. It is a statistical function that only works with values.

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and ...

This function uses the format COUNT(Value1, Value2,…Value[n]), where "n" is limited to a maximum of 255. "Value1" is required, but the other values are optional.

To count multiple criteria in Excel 2003, you have to create an array formula using the SUM function. Open the Excel 2003 spreadsheet where you need to create your formula.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

In this example, we see the number 3, indicating that three students received a grade of F. You can also manually input the range directly into the COUNTIF formula in the cell’s text input bar by ...

Note: Notice how Excel color-codes the formulas to the matching cells, including the opening and closing parentheses, in an effort to help you understand the syntax of each condition in the formula.