howto combine subtotal & sumif?

  • Thread starter Thread starter arvan
  • Start date Start date
A

arvan

can it be done? I'm trying to create a chart that will dynamically
report sales in one column, by rep in a second column and in a variable
(subtotalled) date range from a third column. I'm open to suggestions.
The more complex, the more instructions I'll need.
 
Arvan,

Is there any reason you can't use pivot tables in this
situation. I assume you have some sort of datasheet that
constantly changes? If that's the case, I think a pivot
table is really the way to go.

See Chip's introduction to pivot tables at the following
web address.

http://cpearson.com/excel/pivots.htm

Hope that helps!

Eric
 
Back
Top