Sum Cells based on Background Color - Excel Trick

Method 1: SUM cells on the basis of background colour using SUMIF Formula: We know that SUMIF function is a combination of SUM and IF formula and hence  ...

www.exceltrick.com