Seems to me you ought to just learn how to use Data--Subtotals.
However, you should be able to use SUMIF:
http://www.officearticles.com/excel/index.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jerry" wrote in message
...
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?