I have
column A
with names
subtotal lines

then in the column B
$ values

I want to create a forumula in column C that searches and return only $'s
that are on the lines that contain total in the text string.

any suggestions?