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