I am in need of help to solve a problem in a spreadsheet I have been working on. I need to average a
set of values from several columns and from certain cells in those columns, for example................
BA45 BA66 BA87 BA108 BA129 BA150 BA171 BA192 BA213
Also the same cells from columns BB BO and so on, and this
would continue across other columns and as far down as cell 7663.
I have a formula to average across connected
cells that works fine.
I just can't wrap my head around the correct way to do the same thing from non connected locations. I also need to be able to
have the formula not return the dreaded #Div/0 as not all cells will have a number to return, and the average needs to be
correct with cells that have 0s in them.
I would like to be able to attach this file so someone could take a look
at it but it at this time is over 123mb in size, so that might not be possible through this forum.
If anyone can
point me in the right direction I would be MOST grateful.
In case anyone would need to see this file to fully
understand what I am wanting to do I can upload it to the You Send It site and provide a download link.
I began building this file in Excel 2000 until I ran into the 64mb limit, then started using Excel 2007 preserving the xls