summing only certain rows

[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

 

[Don Guillett]

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

 

[rodchar]

thanks for the help,
rod.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)