Forum Discussion
Solved
Formula worked in google sheets but now doesnt work in Microsoft 365
The formula is =ArrayFormula(SUM(IF(S11=B2:B23,H2:H23),{1,2,3})) It was working in Google sheets, but now doesnt work in Microsoft 365 since i have transitioned. What i am trying to do is fin...
Below is what you want. I've used "IFERROR" for not enough game count.
=IFERROR(SUM(($A$3:$A$18=$C3)*$B$3:$B$18*(ROW($A$3:$A$18)<=SMALL(IF($A$3:$A$18=$C3,ROW($A$3:$A$18),""),COLUMN(C$1)))),"not enough")
COLUMN C is the third column in Excel and COLUMN(C$1) represents 3. You may change it accordingly.
Legend thankyou so much mate!
If you are office365 subscriber, you may write the single array formula as below.
=LET(T,A3:A18,S,B3:B18,G,3,U,UNIQUE(T),CHOOSE(SEQUENCE(1,2),U,MAP(U,LAMBDA(A,SUM(INDEX(FILTER(S,T=A),SEQUENCE(G)))))))