=COUNTIF(Singles!$B$2:$C$74,A2)+COUNTIF(Doubles!$B$2:$F$96,A2)
Would like to have the above in an ARRAYFORMULA but it does not copy down the column as needed. The goal is to show total games played, whether in singles or doubles. I have tested various means, but nothing working in an array formula.
(Singles Tab)
B Col - Home Player
C Col = Away Player
(Doubles Tab)
C Col - Home Player 1
D Col = Away Player 1
E Col - Home Player 2
F Col = Away Player 2
Thanks in advance.
When you had it in an arrayformula, did you have A2:A in place of A2? That should make it work with COUNTIF. I don’t believe COUNTIFS is compatible with arrayformulas.
I think you can keep this in Glide Editor, make a multiple relation to singles tab using the player’s email, then return the total count using a rollup. Do the same for the doubles, then use a math to sum the two rollups.
I agree with @ThinhDinh, This could be done in glide and would work much better.
Not sure if you are still interested but I was looking for something similar…
Put in header row
={"totalGameCount";arrayformula(if(isblank(A2:A),"",COUNTIF(Singles!$B$2:$C,A2:A)+COUNTIF(Doubles!$B$2:$F,A2:A)))}