Sum an Excel range - ignoring blank, text or error cells
The example workbook which the video demonstrates the approaches to the Excel SUMIFS function can be found here:
https://spreadsheetvault.com/excel-su...
This article and video will demonstrate two alternative approaches, using Excel SUMIFS function, to sum a range and ignore blank, text or error cells.
There are many situations, where financial model users require a provisional total of a range; even if there are erroneous cells in a range such as blank, text or error cells.