You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

User profile for user: Snout71
Snout71 Author
User level: Level 1
4 points

Average of cells to end cell of row which is always growing

I have written a formula that will average the numbers in cells in a row, the problem is that the table is growing on a daily basis

the formula is

AVERAGEIF(F43:BX43,"<>0",avg-values)÷1000

tomorrow the range will extend to BY43

so every day I have to edit the formula to extend the range, is there any way I can get the formula to automatically extend the range to the end of the row?

iPad Pro, iPadOS 17

Posted on Nov 7, 2024 3:14 AM

Reply

There are no replies.

Average of cells to end cell of row which is always growing

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up