Menu

macros for calculating a new average after inserting a new row

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

macros for calculating a new average after inserting a new row

try
=average(W:W)

--
Don Guillett
SalesAid Software

"debbz82" wrote in message
...

I was wondering if anyone could help me with this ~~
I am working on a spreadsheet and I need to come up with a macros
that will check all the number in the cells of Column B, so basically
checking row by row. If the number in the cells match, I need to take
the data from the W cell of that row, and keep a running total of the
data in the W cell. All at the same time, I need to keep a count of
how many cells in Column B have the same number, so that I can divide
the running total by this number to find the average score of all these
cells.

For example:

Column B Column W
101 3
101 3
101 6
102 7

In this case, the first 3 rows have the same number for column B. Since
they are the same, I need to add the numbers in Column W of those rows
together , so 3+3+6. Then, since I have counted 3 rows, to find the
average I need to divide 3+3+6 by 3.

Thanks =)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reading SQL Table into Excel and calculating/inserting group line (with VBA)?	Claudia d'Amato	Excel Discussion (Misc queries)	2	January 11th 09 02:53 PM
Calculating Average	ub	Excel Discussion (Misc queries)	2	July 16th 08 05:14 PM
Inserting worksheet calculations into macros	arlen andrews	Excel Worksheet Functions	4	August 15th 07 12:54 PM
Calculating the average	Andy_Trow	Excel Discussion (Misc queries)	3	July 27th 07 02:15 PM
Inserting commands in Macros	Norton704	Excel Worksheet Functions	1	July 28th 05 06:32 PM

All times are GMT +1. The time now is 03:30 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement