How to sum by color in Excel?

Supposing we have a vegetable sales table as below, and we need to count or sum the colored cells. Is there any fast way to deal with this? So how to sum by color in Excel? Let’s check this out! Method 1: Click on any cell and press Ctrl and F to open the Find […]