October 6, 2008 04:33pm pdt

1. b0lsc0tt 7,500
2. tedbilly 5,000
3. capricorn1 4,000
4. Merete 3,350
5. mark_wills 3,164
6. ina_don 3,080
7. apitbajpai 3,000
8. BongSoo 2,500
8. BillBach 2,500
10. chapmandew 2,050
11. TomasHelgi 2,000
11. DanRollins 2,000
11. LindaC 2,000
11. cocofalco 2,000
11. lherrou 2,000
11. moorhous... 2,000
11. anand_2... 2,000
11. jamespfinn 2,000
11. jimpen 2,000
11. syllatrexm 2,000
11. jinesh_ka... 2,000
11. neopolitan 2,000
11. xpsavy 2,000
11. DanielWilson 2,000
11. SQL_SE... 2,000
11. snagsy1... 2,000
11. clayfox 2,000
11. robsantos 2,000
11. dekkar 2,000
11. dtodd 2,000
11. BillDL 2,000
11. TommyTupa 2,000
11. maxis2cute 2,000
11. vishal_im... 2,000
11. gtgloner 2,000
11. TekServer 2,000
11. jvaldes 2,000
11. DanCh99 2,000
11. hielo 2,000
11. meyersd 2,000

1. b0lsc0tt 9,500
2. SStroz 6,350
3. GLCompu... 5,675
4. tedbilly 5,000
5. capricorn1 4,000
6. angelIII 3,500
6. itsmeandn... 3,500
8. ina_don 3,455
9. Merete 3,350
10. mark_wills 3,164
11. TommyTupa 3,000
11. apitbajpai 3,000
13. BongSoo 2,500
13. BillBach 2,500
15. moorhous... 2,150
16. chapmandew 2,050
17. blu 2,000
17. teraplane 2,000
17. robsantos 2,000
17. jamespfinn 2,000
17. humergu 2,000
17. snagsy1... 2,000
17. clayfox 2,000
17. maxis2cute 2,000
17. vishal_im... 2,000
17. SQL_SE... 2,000
17. shuboarder 2,000
17. neopolitan 2,000
17. dqmq 2,000
17. cgordon81 2,000
17. DanielWilson 2,000
17. tbarbe01 2,000
17. computered 2,000
17. xpsavy 2,000
17. Arrow_1 2,000
17. gtgloner 2,000
17. anand_2... 2,000
17. lorenkoeman 2,000
17. TekServer 2,000
17. dovidmichel 2,000
17. DanRollins 2,000
17. TomasHelgi 2,000
17. meyersd 2,000
17. realevergod 2,000
17. lherrou 2,000
17. todd5524 2,000
17. grakem 2,000
17. Pricejr 2,000
17. BillDL 2,000
17. dougcast... 2,000
17. warrenbu... 2,000
17. LindaC 2,000
17. jinesh_ka... 2,000
17. syllatrexm 2,000
17. dekkar 2,000
17. faisalmalaeb 2,000
17. michko 2,000
17. DanCh99 2,000
17. andrewbl... 2,000
17. cocofalco 2,000
17. hielo 2,000
17. Wizilling 2,000
17. jimpen 2,000
17. dtodd 2,000
17. LoNeRaV... 2,000
17. asian_nic... 2,000
17. ylandrum 2,000
17. jvaldes 2,000
17. seriousnick 2,000

02.22.2007 at 08:19AM PST, ID: 22406662

	[x] Attachment Details

Perform Caluclations with Subtotals in a Macro (Excel)

Asked by NTGuru705 in Software, Microsoft Excel Spreadsheet Software

Tags: excel, macro, subtotal

I have a problem with Excel... I insert subtotals of some columns but then I need an average of the subtotals. How can I accomplish this... I could average the column but that wont work... because the column is averages... basicallly I need to sum some columns and then use the subtotals to calculate an average...

One column is a frequency and one column is a number of widgets per instance of the frequency. So what I want to do is sum the frequency (count how often) and then sum the number of widgets per instance and then divide to get an average per frequency... So in my subtotal I want to sum two columns then use the resulting totals to divide by each other.

I can do this just fine by hand but I want to put it into a macro... which makes it tough because I dont have a predefined number of row per break so I never know where these subtotal rows will be.. so I need to figure out some way to do this either by finding the subtotal tow or perhaps some unknown function in Excel that already handles this... PLEASE HELP.. Start Free Trial

Keywords: Perform Caluclations with Subtotals in …

	Title
1	Getting Multiple Subtotals in Excel with …
2	Macro to Chart Subtotaled Data
3	Macros to add rows and subtotals
4	Removing Subtotals Deletes Header Row
5	Subtotal at change in...
6	multiplication and subtotals

Loading Advertisement...

20080716-EE-VQP-32

Perform Caluclations with Subtotals in a Macro (Excel)

Asked by NTGuru705 in Software, Microsoft Excel Spreadsheet Software

Tags: excel, macro, subtotal

About this solution