Average non zero cells over multiple columns.

**davem1943** · 01-03-2012, 06:20 PM

I am a novice to Excel and needing some help.

How do I get an average of non zero, or non blank cells in multiple columns that are not adjacent?

In my case I have cells b3:b14, g3:g14, l3:l14, q3:q14 and v3:v14 that contain both negative and positive numbers. I need to find the average of all cells in these columns with any value entered other than zero.

**TMShucks** · 01-03-2012, 06:29 PM

Sum the cells and divide by the number of cells minus the number of zero cells minus the number of blank cells.

Regards, TMS

**davem1943** · 01-03-2012, 09:55 PM

Thanks for the response.

I understand that is how I would come up with the average. What I am looking for is a formula which will do this for me since I will be adding data into these cells. I understand that this may be something simple that I am overlooking but where I run into a problem is when I get into multiple columns.