Too few Arguments

[americanpie3]

Someone's arguing.

=IFERROR(SUM(Week2!AC22:AC24)+(INDEX(StatsWeek1!$B$5:$B$10,MATCH(A5,StatsWeek1!$A$5:$A$10,0)))),0)

 

[mikerickson]

It looks like the INDEX needs a column argument.

 

[T. Valko]

Someone's arguing.

=IFERROR(SUM(Week2!AC22:AC24)+(INDEX(StatsWeek1!$B$5:$B$10,MATCH(A5,StatsWeek1!$A$5:$A$10,0)))),0)

You have too many closing parentheses.

=IFERROR(SUM(Week2!AC22:AC24)+INDEX(StatsWeek1!$B$5:$B$10,MATCH(A5,StatsWeek1!$A$5:$A$10,0)),0)

 

[americanpie3]

Too many brackets.

Thanks fellas

 

[T. Valko]

Too many brackets.

Thanks fellas

=IFERROR(SUM(Week2!AC22:AC24)+INDEX(StatsWeek1!$B$5:$B$10,MATCH(A5,StatsWeek1!$A$5:$A$10,0)),0)

I'm curious as to the construction of that formula.

Is this what you actually had in mind:

=SUM(Week2!AC22:AC24)+IFERROR(INDEX(StatsWeek1!$B$5:$B$10,MATCH(A5,StatsWeek1!$A$5:$A$10,0)),0)

Or, maybe even this:

=SUM(Week2!AC22:AC24)+SUMIF(StatsWeek1!$A$5:$A$10,A5,StatsWeek1!$B$5:$B$10)