Text criteria which results in value

[jyoakley]

Helppppppp.

I need a formula that search text criteria if = then sum all that matches that criteria.

 

[just_jon]

Helppppppp.

I need a formula that search text criteria if = then sum all that matches that criteria.

Welcome to MrExcel - do you mean something like count all instances in a column of "ABC"?

=COUNTIF(A:A,"ABC")

If you want to sum one column based on another, then

=SUMIF(A:A,"ABC",B:B)

Where column A holds your Text, and if applicable column B holds vlues to sum.