How to use offset in order to find the last 10 'games'

Question

Created Jun ’21

Replies 1

Boosts 0

Participants 1

I am trying to create a formula using Numbers by Mac in order to find how many of the last 10 games we won. Although I know how many games there are, we are in mid-season.

I am able to use this formula in Excel: =COUNTIF(OFFSET(C3,COUNTA(C3:C17),0,-E3-1),"Yes")

and it works just fine.

However, when I use this formula in Numbers for Mac, I get an error saying:

Argument 4 in OFFSET must be greater than or equal to 1 and less than or equal to 1,000,000.

Screen Shot 2021-06-21 at 5.00.32 PM.png

Can you provide any suggestions?

Thanks in advance! Melissa

Answered by mbain108 in 680002022

ANSWER: =SUM(OFFSET($A$1,COUNTA(A)−9,0,10))

Boost

Answer 1

mbain108 OP

Jun ’21

Accepted Answer

ANSWER: =SUM(OFFSET($A$1,COUNTA(A)−9,0,10))

0