On my spread sheet I have 12 cells in a row to track each months perfromance
results as a percentage. Then I have a cell to give the overall percent year
to date.
In the overall percentage cell I entered this formula:
=(B2+C2+D2+E2+F2+G2+H2+I2+J2+K2+L2+M2)

This works but I have to keep adding to the end of the formula to divide my
how many months we are into the year to get the results.
=(B2+C2+D2+E2+F2+G2+H2+I2+J2+K2+L2+M2)/4

Is there a way to tweek this formula that it will divide by how many cells
have a value entered ?

Thanks - George