Thread
:
AVERAGE ARRAY
View Single Post
#
1
Posted to microsoft.public.excel.misc
vukgar
external usenet poster
Posts: 1
AVERAGE ARRAY
I would like to average the 1st 7 numbers in an array (E2:E63), in the next
colum I need to average the 1st 30 numbers of E2:E63). I have tried using
=AVERAGE(E2:E63),ROW(1:7), but the number returned is double than what it
should be
Reply With Quote
vukgar
View Public Profile
Find all posts by vukgar