myResult = Application.Average(Range("b2:b24"))
Code:myResult = Application.Average(Range("b2:b24"))
Do the non-blank cells contain formulas, or constants, or both?Hi, MrExcel
How can i make an average of a range of cell P9 to all cells that contain data to the left in the same row.
Regards.
Hi, MrExcel
How can i make an average of a range of cell P9 to all cells that contain data to the left in the same row.
Regards.
myresult = Application.Average([A9:P9])