Eric Kelcher
Board Regular
- Joined
- May 11, 2006
- Messages
- 130
I need a macro to compute the average for cells that have an unknown range. I am having an issue as the cells to compute the average of have a formula in them and if there is no data for that formula it is dividing by zero thus #DIV/0! So how do I make a macro figure the cells that have real data in them? or better how do I get the formula to appear if there is values in the relevant cells. (fairly uniform (b2-b3+1)/b3, (c2-c3+1)/c3...) then I want allt he cells that have formula in them to be averaged.
I thought I had it figured out to compute how many cells had info in them but the #DIV/0 threw me for a loop, and miscalculated.
I thought I had it figured out to compute how many cells had info in them but the #DIV/0 threw me for a loop, and miscalculated.