Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using both sum and average in subtotals
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.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using both sum and average in subtotals
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. Guru wrote: 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.. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using both sum and average in subtotals
wow..thats perfect...u saved lot of time ..Thanks a bunch...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I subtotal then average the subtotals | Excel Discussion (Misc queries) | |||
how can you average subtotals of visible cells only? | Excel Worksheet Functions | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
AVERAGE() of subtotals | Excel Discussion (Misc queries) | |||
Get Average in Subtotals | Excel Programming |