To sum by color in Excel 2013 (and previous versions) you must create a VBA Module. Don’t worry, it sounds scarier than it is. Follow these steps to create a new function called SumByColor to your workbook. Press ALT+F11 to open Visual Basic for Applications Click Insert | Module Paste in the following code: Function…