Try this version with SUMIFS
=IF(D7="","",SUMIFS(FullWPlStats!G:G,FullWPlStats!A:A,D7,FullWPlStats!B:B,"<="&G1))
That will sum column G when A matches the player in D7 and week number in B is <= week number in G1
Try this version with SUMIFS
=IF(D7="","",SUMIFS(FullWPlStats!G:G,FullWPlStats!A:A,D7,FullWPlStats!B:B,"<="&G1))
That will sum column G when A matches the player in D7 and week number in B is <= week number in G1
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks