Numbers Formulas Help

What was your formula in Excel? Unless it was an array formula (not supported in Numbers), we might be able to do something to make it work. Sometimes array formulas can be reworked, too.

Assuming it will always be 3 games (or fewer) per week,

Use the gray columns to do some of the work

D24 =IFS(AND(B24=B$29,C24=C$29),5, OR(B24=B$29,C24=C$29),1,TRUE,0)

Fill that to the rest of the cells in the column

Set the text color to match the background fill so you don't see the results

Copy/paste the column of formulas to columns G and J.

K24 =SUM(D24,G24,J24)

Fill that to the rest of the column

If there will be 4 game weeks, you might want to put those additional 3 columns into the spreadsheet for every week.

For weeks with fewer games, put NA or NO GAME or something like for the scores of those games so they don't get counted.

The 1 point formula will not work because Numbers won't use booleans (true/false) as numbers in SUM. But you can use COUNTIF instead.

=COUNTIF({C10=C$38,D10=D$38,F10=F$38,G10=G$38,I10=I$38,J10=J$38},TRUE)

The 3 point formula from Excel should work the same in Numbers. Or you can rewrite it using COUNTIF

=3*COUNTIF({AND(C10=C$38,D10=D$38),AND(F10=F$38,G10=G$38), AND(I10=I$38,J10=J$38)}, TRUE)

Non sono un esperto, ma questo sistema sembra funzionare. Alla fine nascondi le colonne I; J; K; L; M; N