Forum Discussion

djs72's avatar
djs72
Copper Contributor
May 09, 2023

Script to count and total varying window sizes

Hi.   I'm working on a spreadsheet and I want to create a script where it will look at the plan name (Column A), then take the window sizes from Columns B and C and the Optional "z" and total them ...
Macros and VBA
Lorenzo's avatar
Lorenzo
Silver Contributor
May 10, 2023

djs72 

Another 365 option

 

 

EDITED (shortened):

=LET(
  uniq,  UNIQUE(IF(TableInput="", "", TableInput)),
  k,     SEQUENCE(4,,,0),
  count, LAMBDA(r, SUM(--(MMULT(--(TableInput=r),k)=4))),
  VSTACK(
    HSTACK(TableInput[#Headers],"TOTAL"),
    HSTACK(uniq, BYROW(uniq, count))
  )
)

 

Resources