How to count numbers by color in Excel

The specific steps for counting numbers by color are as follows:

1. Create a name manager

The cell is set in In cell A1, select [Formula]-[Name Manager], add a name as data, and the reference position is: =GET.CELL(63,Sheet1!A1)

2. Cell filling data

Enter = data in cell A1, fill to the right without formatting, and fill all cells with color downwards.

3. Use the counting function to count

Enter the formula =COUNTIF($A$1:$D$5,F1)

in cell G1

Fill down, and you will get the counts corresponding to various colors

For more Excel-related technical articles, please visit the Excel Basic Tutorial column !

The above is the detailed content of How to count numbers by color in Excel. For more information, please follow other related articles on the PHP Chinese website!