View Single Post
  #3   Report Post  
Old July 7th 11, 03:51 AM posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2011
Posts: 84
Default Help With Formula For Cell Addresses

On 07/04/2011 06:15 PM, zvkmpw wrote:
Maybe something like this would help.

Put this in V4 and copy down:

I started in row 4 because row 3 has the headings.

If all the cells in an average are empty, there will be a #DIV/0
error. If this is a possibility with your data, add a check for this

Modify as needed.

Perfect, thanks!