1In a blank cell C13 for example enter this formula. Change the letters and numbers in parenthesis to fit your workbook. SUM helps users perform a quick summation of specified cells in MS Excel.
2 Sum by Color using GetCell Function.
The names of the vegetable names of suppliers and quantity are in column A column B and column C respectively. The SUM formula in Excel is one of the most basic formulas you can enter into a spreadsheet allowing you to find the sum or total of two or more values. For example to add together the numbers 2 7 and 1 type the following into any Excel cell. The second approach is explained to arrive at the sum of the color cells in excel as discussed in the below example.