Forum Discussion

mapua21's avatar
mapua21
Copper Contributor
Mar 27, 2023

adding downward columns across an excel sheet

i am trying to add columns across an excel spreadsheet. So.. say from row 254 to 321. is there a quick way of doing this for columns say C to P  
excel
Patrick2788's avatar
Patrick2788
Silver Contributor
Mar 28, 2023

mapua21 

I'm going to take a guess here and venture to say you know how to SUM ranges.  I'm guessing you're looking for a way to do this with a spill - a single input.

 

If this is the case, this may work for you:

 

=BYCOL(arr,LAMBDA(col,SUM(col)))

 

 

  • mapua21's avatar
    mapua21
    Copper Contributor
    Mar 28, 2023
    =BYCOL(arr,(CDEFGHIJKLMN(col,SUM(col)))
    thanks Patrick,
    here is what I entered but a sign pops up saying "the formula is missing an opening or closing parenthesis"
    • mathetes's avatar
      mathetes
      Silver Contributor
      Mar 28, 2023

      mapua21 

       

      To save Patrick2788 from having to respond, his formula read 

      =BYCOL(arr,LAMBDA(col,SUM(col)))

       

      Yours is 

      =BYCOL(arr,(CDEFGHIJKLMN(col,SUM(col)))  with the additional, extraneous opening parenthesis highlighted in red. It's that additional one that means you should have four at the end, as contrasted with his three. Or you can remove the red one, which is unnecessary.

       

      HOWEVER, you also have some entirely different grouping of letters, different from his LAMBDA in yours...is that just something that popped up as you wrote your most recent post? For LAMBDA to work, you do need to be working with a Microsoft 365 subscription, by the way.

      • mapua21's avatar
        mapua21
        Copper Contributor
        Mar 29, 2023
        thank you both for your help, I will check with some people I know here that I can show what I need to see if I can get a quick solution. In the meantime I have done it "longhand" so to speak.
        thanks again for your effort, much appreciated.

Resources