Jan 08 2019
04:14 PM
- last edited on
Jul 12 2019
11:19 AM
by
TechCommunityAP
Jan 08 2019
04:14 PM
- last edited on
Jul 12 2019
11:19 AM
by
TechCommunityAP
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))
Jan 08 2019 04:24 PM
Jan 08 2019 09:13 PM
Jan 09 2019 12:32 AM
SolutionInstead of SUM(V3:V444) it could be something like
=SUM(OFFSET(V3,0,0,COUNTA(V3:V10000)))
etc
Jan 09 2019 11:48 AM
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
Jan 09 2019 12:32 AM
SolutionInstead of SUM(V3:V444) it could be something like
=SUM(OFFSET(V3,0,0,COUNTA(V3:V10000)))
etc