📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

delete wrong place moved to techie

david1946
david1946 Posts: 47
Fifth Anniversary 10 Posts Combo Breaker
Forumite
edited 13 February 2022 at 4:17PM in Energy
.                       .
sorry wrong place
moved to techie

Comments

  • QrizB
    QrizB Posts: 25,520
    10,000 Posts Fifth Anniversary Photogenic Name Dropper
    Forumite
    I don't quite understand the question, sorry.
    You've already got the formula to sum eleven adjacent cells.
    Are you looking for a way to automatically insert that formula into every 48th cell in a particular column? That would need a macro, not a formula.
    N. Hampshire, he/him. Octopus Intelligent Go elec / Fuse gas / Vodafone BB / iD mobile. Kirk Hill Co-op member.
    2.72kWp PV facing SSW installed Jan 2012. 11 x 247w panels, 3.6kw inverter. 37 MWh generated, long-term average 2.6 Os.
    Economy 7 cap explainer. Gas vs E7 vs peak elec heating costs, Ecoflow Stream, Best kettle :-)
  • theoretica
    theoretica Posts: 12,691
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    Forumite
    If you put the formula in C50 and C98 and then fill down it should do it automatically.
    But a banker, engaged at enormous expense,
    Had the whole of their cash in his care.
    Lewis Carroll
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 356K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.3K Spending & Discounts
  • 248.5K Work, Benefits & Business
  • 606.2K Mortgages, Homes & Bills
  • 179.1K Life & Family
  • 264K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards
Quick Search

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.