Forum Discussion
Solved
Excel auto sum not working on values calculated using formula.
I want to create a formula for SUM and AVERAGE that has a variable number of rows. Here is the example where the 444 count varies from worksheet to worksheet. I have saved this formula and easy ...
Instead of SUM(V3:V444) it could be something like
=SUM(OFFSET(V3,0,0,COUNTA(V3:V10000)))
etc
