Notifications
Clear all
Topic starter
Hello all!
I have this formula below to sum each column in a spilled range which works beautifully! But I was wondering, if it is possible to AGGREGATE the values? Meaning, if a user filters the range, I want the sum to not include hidden values. Similar to what =AGGREGATE(9,5,$B$15:$B$20) would do.
Thanks in advance!
=LET(
qty,$B$13#,
qty0,IF(ISNUMBER(qty),qty,0),
u,SEQUENCE(1,ROWS(qty),1,0),
MMULT(u,qty0)
)
Posted : 28/10/2023 11:28 am
Hi Kenneth,
I would think so, but it's a bit difficult to follow what your formula is doing without an example file because on the face of it, MMULT seems like overkill.
Perhaps you could share a mockup of what you're wanting to do.
Mynda
Posted : 29/10/2023 9:13 am
How about
=BYCOL(B13#,LAMBDA(bc,AGGREGATE(9,5,bc)))
Posted : 01/11/2023 11:09 am
