It would appear that SUMIF() does exactly this
=SUMIF(test-range, “test”, [sum-range])
Conditional SUM() based on text of a cell using iWork
It would appear that SUMIF() does exactly this
=SUMIF(test-range, “test”, [sum-range])