summing only certain rows

R

rodchar

hey all,

i have an excel report like this:

area, rep, sales
----------------
area51, rep1, $5
area51, rep2, $5
subtotal_area, ,$10
area52, rep1, $7
area52, rep2, $7
subtotal_area, ,$14

think of the commas as separate cells. is there an easy way to add just the
subtotal rows total together? like pick the rows out by the string
"subtotal_area" and 2 cells to right and grab that number and total it?

thanks,
rodchar
 
Top