Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Average If Macro
Hi all!
I'm not quite sure whether this is feasible or not, however I guess I can give it a shot. I have a worksheet with 3 different tabs: i) Jan-Jun03 ii) Jul-Dec03 iii) Jan-Apr04 In each of these tabs I need to average a range of criteria in column "D". The entries in column D range from -5000 to 6000 or so and it goes on for about 50000 rows in each tab. Here's the catch; I need to average based on intervals. I need it to give me an average for the range of data between entries that go below 15. So basically, everytime the data goes below 15, I should get an average based on all prior data greater than 15. When an entry goes below 15 is totally random. If all the average intervals could go in column "M", that would be great!!! If further information is required, do not hesitate to tell me! Feel free to post or email me!!! Thanks in advance, Kris Taylor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort, select and average macro help | Excel Discussion (Misc queries) | |||
Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
moving the formula "average" over one column in a macro | Excel Worksheet Functions | |||
Average Macro | Excel Discussion (Misc queries) | |||
Variable sized average macro/function | Excel Programming |