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
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