Forum Discussion

Copper Contributor

Mar 01, 2023

Solved

How to count

Hi, need some help with below topic : - in the template, the range B1:B12 - have some numbers - want to summary on those columns , which are define by number , which is indeecated separatly eg....

Formulas and Functions

OliverScheurich
Mar 01, 2023
Tom67K
=SUM($B$5:INDEX($B$5:$P$5,J1))
This formula returns the intended result in my sheet.

OliverScheurich

Gold Contributor

Mar 01, 2023

Tom67K

=SUM(INDIRECT("B1:B"&J1))

You can try this formula if you want to sum the ranges.

Tom67K
Copper Contributor
Mar 01, 2023
OliverScheurich

Have tried witha rows and failed 😞

What should I change?
- PeterBartholomew1
  Silver Contributor
  Mar 01, 2023
  Tom67K
  For me it changes the formula to
  = SUM(TAKE(data,1,N))
- OliverScheurich
  Gold Contributor
  Mar 01, 2023
  Tom67K
  =SUM($B$5:INDEX($B$5:$P$5,J1))
  This formula returns the intended result in my sheet.
  - Tom67K
    Copper Contributor
    Mar 02, 2023
    You are amazing, Thx !