formula to return certain cell

J

jerry

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?
 
Top