The formula below works perfectly to find the number being matched but I need it to also calculate the SUM of a range with the last cell of that range being the matched cell, in this case TeamStats!F13, and the first cell of the range to be TeamStats!F5.
=IF(C6="","",IF(ISERROR(INDEX(TeamStats!F:F,MATCH($E$1&C6,TeamStats!B$1:B$1271&TeamStats!A$1:A$1271,0))),"",INDEX(TeamStats!F:F,MATCH($E$1&C6,TeamStats!B$1:B$1271&TeamStats!A$1:A$1271,0))))
Thanks!
Bookmarks