Aug 31 2021 09:36 PM
I am trying to figure out a billiard question. see sheet for breakdown. i think it needs a combination of sumproduct and index match. or maybe sumproduct and countifs. ive tried different ways but i cant figure it out
Sep 01 2021 02:13 AM
SolutionSep 01 2021 10:00 PM
Sep 01 2021 10:38 PM - edited Sep 01 2021 11:13 PM
i think i figured it out
=SUMPRODUCT((A2:A5=1)*(B2:B5="a")*(C2:C5=3)*(I1:L1=C2:C5)*(I2:L5="bottom left"))
Sep 01 2021 02:13 AM
SolutionTry this:
=SUMPRODUCT((B2:B5=H1:K1)*(H2:K5="top left"))