how can i adapt my formula to include 1 more column? my present formula is =SUMPRODUCT(--(B$2:B2&E$2:E2=B2&E2),J$2:J2) How can i include
cell G2 ? this is what i came up with but it dont work just returns a 0 -
=SUMPRODUCT(--(B$2:B2&E$2:E2&G2:G2="Yc"=B2&E2&G2),J$2:J2)B is a a teamE is a playerG is Yellow cardJ is always a number 1 if he has received a yellow card during the game so when all those criterias match it returns 1 and when it next meet the
first formula above works brill only i need to add g2 i dont need
anything else changed only include G2 in formula
cell G2 ? this is what i came up with but it dont work just returns a 0 -
=SUMPRODUCT(--(B$2:B2&E$2:E2&G2:G2="Yc"=B2&E2&G2),J$2:J2)B is a a teamE is a playerG is Yellow cardJ is always a number 1 if he has received a yellow card during the game so when all those criterias match it returns 1 and when it next meet the
first formula above works brill only i need to add g2 i dont need
anything else changed only include G2 in formula