Sum Help

Brass Contributor

How to sum a column if another contains a text. The issue I am running into is that the text is found in the column repeatedly. Attached is an example of the workbook I am working with.

2 Replies


Why would this be an issue?

Use SUMIF(), SUMIFS() or a pivot table.