Thread
:
dynamic average for cells
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
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 With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy