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
 
R

rodchar

thanks for the help,
rod.

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top