Forum Discussion

MVEBA's avatar
MVEBA
Copper Contributor
Jan 09, 2019

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 enough to use but want to develop something similar but with many more columns.  Worth some time and effort as I evaluate the averages many times a week as they can change daily.

 

=SUM(V3:V444)/(SUM(CC3:CC444)+SUM(CD3:CD444))

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

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

    etc

     

  • 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

      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

  • Hi
    Can you give a bit more information about what you need, ideally attaching an example?
    • MVEBA's avatar
      MVEBA
      Copper Contributor
      I will send the whole spreadsheet tomorrow and not sure what else I can say. It is a list of hundreds of home sales with 40 or so fields of information. I want to use the sums of 4 or 5 columns (fields) for averages between 2 or 3 fields at a time. For example-divide sum of one field by sum of another add three of those averages together and divide by the number of fields used.

Resources