Dynamic formula

J

Jason

I have a formula that calculates an average of either 10 or 11 rows of data.
I would like to be able to make the formula dynamic so that I can average
either 10 or 11 rows, based on a countif function and some other data.

Any help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation Based on Dynamic Variables (What-if Scenario) 0
Clicking link tasks again increases duration 0
Finding the weighted average of text that have been given values 1
Need help finding old, outdated contacts in Outlook 365 on my PC 0
Average Unique 7
Average If... 12
#DIV error 2
Linking Child Timelines to Multiple Parents 0

Top