I need to calculate weekly and daily averages from hourly data of about 1.5 years.
I tried using an array formula (for the first time) based on WEEKNUM from an older thread on this website -
=AVERAGE(IF(D1=$D$2:$D$864,$B$2:$B$864,""))
col D: weeknum and col B: value
I guess, as some of the week numbers are repeated, I get wrong values for those weeks. Is there a solution for this?
My knowledge of array formulas is 1 hr old and I plan to look into the basics but I just need to finish this one task right away.
Thanks in advance!
Bookmarks