Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic average for cells
I have 12 columns each representing a month of the year.
at the end of each month a percentage is entered for that month. so at the end of july numbers will be entered for january-july. Now at the end of these months i want to put a formula that will average the numbers for the 12 months that will be able to average only january - july while not factoring in august - december. the months that are not entered will have null values. I will greatly appreciate any help with this. thanks a lot... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic average for cells
If the cells for future months are empty, the Average function will ignore
them. -- Regards, Tom Ogilvy wrote in message ... I have 12 columns each representing a month of the year. at the end of each month a percentage is entered for that month. so at the end of july numbers will be entered for january-july. Now at the end of these months i want to put a formula that will average the numbers for the 12 months that will be able to average only january - july while not factoring in august - december. the months that are not entered will have null values. I will greatly appreciate any help with this. thanks a lot... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic average | Excel Discussion (Misc queries) | |||
Dynamic average | Excel Worksheet Functions | |||
Dynamic Average Question | Excel Discussion (Misc queries) | |||
Average dynamic data cells over a one hour period? | Excel Discussion (Misc queries) | |||
Dynamic Average | Excel Worksheet Functions |