Forum Discussion

MVEBA's avatar
MVEBA
Copper Contributor
Jan 09, 2019
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 ...
BI & Data Analytics
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 09, 2019

    Instead of SUM(V3:V444) it could be something like

    =SUM(OFFSET(V3,0,0,COUNTA(V3:V10000)))

    etc

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 09, 2019

Instead of SUM(V3:V444) it could be something like

=SUM(OFFSET(V3,0,0,COUNTA(V3:V10000)))

etc

 

  • MVEBA's avatar
    MVEBA
    Copper Contributor
    Jan 09, 2019

    Thank you so much.  I have each column working perfectly and just need to put it all together with correct number of parentheses.

    Best,

    Fred

Resources