Excel COUNTIF and SUMIF Formula by Cell Color 2.1 COUNTIF Formula with Cell Color ![]() However, the last two pictures show the result of filtered cells only.Ģ. □ The result at the start shows all the data in the range. □ As reference both the formulas take a range of the quantities. □ SUBTOTAL takes two arguments function_name and ref1.In the function_name it takes 102 for counting the number of data and 109 to return the sum of the quantities. The results show the count and sum of only the filtered data You can notice the changes of values in Count by Color and Sum by Color in the pictures below. ![]() Now, choose the color that you want to filter.Click on the arrow symbol of the column Name.You will find two arrows in the columns of the dataset. From the Home tab, Select Filter in Sort & Filter drop-down menu.
0 Comments
Leave a Reply. |