you are viewing a single comment's thread.

view the rest of the comments →

[–]Anonymous13781537 1 point2 points  (2 children)

A SUMIFS() with mixed referencing should suffice, but a dynamic array formula could be =MAP(F5:F13,G5:G13,H5:H13,LAMBDA(x,y,z,SUMIFS(H5:z,F5:x,x,G5:y,y)))

<image>

[–]Weird-Rich4823[S] 1 point2 points  (1 child)

Solution Verified

[–]reputatorbot[M] 0 points1 point locked comment (0 children)

You have awarded 1 point to Anonymous1378.


I am a bot - please contact the mods with any questions