I was helped with this code in 6-2024 - it seems to not be adding last value so the formula may need 2 be modified @BYROW(UNIQUE

[RudeBoy]

I used the code a few weeks ago and it worked great accept for the last person it left out the last total?
Here was the code used:

=@BYROW(UNIQUE(A19:C19),LAMBDA(br,TEXTJOIN(" ",1,br,"=",SUMIFS(F19:F56,A19:A56,@INDEX(br,0,1),B19:B56,@INDEX(br,0,2),C19:C56,@INDEX(br,,3)))))

I have enclosed a pic of the data. The total for all of Anthony Vanderaa should be 594 but the formula above returned a total of 484. I am not sure why it left out the last total of 110?

Thanks for your help - this is a post you had helped me on back in June of this year.

 

[MARK858]

Maybe column A is your issue, where all the values totaled have 18d in column A, whereas the 110 has 22b in Column A

=@BYROW(UNIQUE(A19:C19),LAMBDA(br,TEXTJOIN(" ",1,br,"=",SUMIFS(F19:F56,A19:A56,@INDEX(br,0,1),B19:B56,@INDEX(br,0,2),C19:C56,@INDEX(br,,3)))))

 

[RudeBoy]

Maybe column A is your issue, where all the values totaled have 18d in column A, whereas the 110 has 22b in Column A

=@BYROW(UNIQUE(A19:C19),LAMBDA(br,TEXTJOIN(" ",1,br,"=",SUMIFS(F19:F56,A19:A56,@INDEX(br,0,1),B19:B56,@INDEX(br,0,2),C19:C56,@INDEX(br,,3)))))

Thank You so much, that pointed me in the right direction and I was able to find the bug in the process and fix it.

 

[Peter_SSs]

@RudeBoy
I have edited your thread title. Please review #4 of the Forum Rules so such edits are not required in future.
Thanks.

 

[MARK858]

You're welcome, happy it helped

P.S. you might want to state that you have worked it out in your other thread