using both sum and average in subtotals

  • Thread starter Thread starter Guru
  • Start date Start date
G

Guru

Hi,

I'm very new to excel VBA programming..can any body please suggest a
easy solution for the following:

I need to use both sum and average in subtotal function on different
columns at a time..

eg: Column A : Name
Column E: Rate
Column F: net value

I want to do sum on Column F and average on Column E for every change
in column A...

Any help will be greatly appreciated..

Thanks..
 
Do your data|subtotals
and use Sum for both columns

Then select column E
edit|replace
what: =subtotal(9,
with: =subtotal(1,
replace all

(9=sum and 1=average, right???)

If you've been really good, I bet you don't have any =subtotal()'s in that
column--except from the ones your data|subtotal added.
 

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

Similar Threads

SUBTOTAL SUM AND AVERAGE 2
Calculating subtotals 22
Subtotal with more than one Function 3
Conditional SUBTOTAL in XL210 Table 7
Subtotal function 2
Average of Subtotals in Pivot Table 0
select range in column, calculate on range plus 3 columns, output inrange plus 7 columns 8
Subtotal Formatting 2

Back
Top