Sum Help

[CatherineMadden]

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]

@CatherineMadden 

Why would this be an issue?

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

[#3]

@CatherineMadden 

=SUMIF(A2:A33,D2:D7,B2:B33)