Forum Discussion
adding downward columns across an excel sheet
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)))
thanks Patrick,
here is what I entered but a sign pops up saying "the formula is missing an opening or closing parenthesis"
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.
- 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.I'm confused. It sounds like now you're saying there is (or there was) a very specific need to accomplish a very specific task, and that at work. The way you were wording your request earlier (e.g., the quote below) sounded more abstract, curious whether such and such was possible.
Yes I realise I can add doing what you suggested, but I just want to go along a row and add up a section of each column, not the complete column and I wondered if there was a quick way to do it.
I want to =SUM columns A to M, but only rows (say) 10-30 within those columns.
Is this possible.
Now it sounds like your casual use of "(say)" there was just one example of what could be a number of selective ranges of sums you wanted to accomplish. If that's the case, it wasn't clear to me. Sounded more abstract and arbitrary......which is why my own emphasis was on learning by experimenting. If you don't find the specific help you need, perhaps you would be willing to come back and spell out more specifically, fully, what the situation is. Ideally, if the data aren't confidential, you could post a copy of the workbook on OneDrive or GoogleDrive, with a link pasted here that grants access.
