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

try
=sumif(a2:a22, "subtotal_area",c2:c22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

thanks for the help,
rod.

"Don Guillett" wrote:

try
=sumif(a2:a22, "subtotal_area",c2:c22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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