The value we used, 38, returns a cell’s fill color. For instance, to sum the values, you’d use 5 instead of 38 when creating the range. Then, you’d use SUMIF () instead of COUNTIF ().

How to manually sum in Excel 1. Click the cell you want the sum to appear in and click "=." 2. Type a number or click a cell that has a value. 3. Type "+." 4.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.