View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default How to avergage colums

Hi Milo,

Am Sat, 6 Apr 2013 05:11:49 +0000 schrieb Milo Bloom:

I have attached the file with all the sheets in it, Column C is "Data"
and the last column is the one I am looking for the answer to. "Run Avg"


please look he
https://skydrive.live.com/#cid=9378A...121822A3%21191
for your workbook "question sheets", right-click and download
For April to Juli I entered a suggestion in column I or J.
For January to March you can't do it in a simplier way.
You sometimes forgot to set the reference absolut.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2