How do you get the averages in Autotap using MS Excel?
TECH Addict
Joined: Nov 2001
Posts: 2,003
Likes: 0
From: Live Oak, FL - in the woods where the creatures lurk.
Re: How do you get the averages in Autotap using MS Excel? One way is to go to an empty cell and enter
=AVERAGE(enter or highlight cell range here)
Make sure you use the parenthesis around the cell range.
Or, later Excel versions has a function at the bottom of the page where you can just highlight the cells and it will show the numbers. To change the function, right click on the number at the bottom of the page and select between average,max, min, sum, etc.
Clear as mud?
=AVERAGE(enter or highlight cell range here)
Make sure you use the parenthesis around the cell range.
Or, later Excel versions has a function at the bottom of the page where you can just highlight the cells and it will show the numbers. To change the function, right click on the number at the bottom of the page and select between average,max, min, sum, etc.
Clear as mud?
