Forum Discussion

Tom67K's avatar
Tom67K
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's avatar
    OliverScheurich
    Mar 01, 2023

    Tom67K 

    =SUM($B$5:INDEX($B$5:$P$5,J1))

    This formula returns the intended result in my sheet.

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Mar 01, 2023

Tom67K 

A non-volatile formula that requires Excel 365

= SUM(TAKE(data, N))

where 'data' is $B$1:$B$15 and 'N' is $J$1.

Resources