add up all values that contain certain text

[bigdan]

i'm doing my accounts and want to find a way to automate it.

for each month there's a number of transactions that were cash ones, debit, etc. i want to add up all the transactions that have, say, "merchandise" in the desc. however the desc wont necessarily start or end with that text, just have it in there somewhere. how would one do this?

the text col is B, the corresponding values are in C, and the result is to be output in one cell in, say, H. how would i do this?

thanks!

 

[cstimart]

Something like this should work.

=SUMIF(B:B,"*merch*",C:C)

 

[wigi]

Hello there

For instance

=SUMIF(A1:A20,"*merchandise*",B1:B20)