• 470K Members
• 5,515 Online
• 568K Conversations

## How to run a 24-cell block formula

Occasional Visitor

# How to run a 24-cell block formula

Good morning, I have a small problem and I wanted to know if anyone can support me. What I need is for my Excel formula to take 24 cells to get an average and to drag it take the next 24 cells, that is, if I take from cells 1 to 24 when dragging my formula take it from cell 25 to 48. I would appreciate it Much your support.

2 Replies

# Re: How to run a 24-cell block formula

Please use below formula, it will give average of numbers with the gap of 24 rows, for example 1st it will give average of 1 - 24 row, when you drag it will give average from 25 to 48 and so on.

=AVERAGE(OFFSET(\$C\$5:\$C\$244,((ROW(C5)-ROW(\$C\$5))*24),0,1,1):OFFSET(\$C\$5:\$C\$244,((ROW(C5)-ROW(\$C\$5))*24),0,24,1))

Excel file is also attached for your reference.

Hope it will hep you

Thanks

Tauqeer

# Re: How to run a 24-cell block formula

Assuming your values are in Column A, a shorter non-volatile formula, starting in B1, is:
=AVERAGE(INDEX(A:A,ROW()*24-24+1):
INDEX(A:A,ROW()*24))
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies