To get you on the right track, this would be the way to sum the values between the specified limits:
=SUM(INDEX(Data!B:B,MATCH(B2,Data!A:A,1)):INDEX(Data!B:B,MATCH(C2,Data!A:A,1)))
that sums the range: Data!B6639:B6665
To get you on the right track, this would be the way to sum the values between the specified limits:
=SUM(INDEX(Data!B:B,MATCH(B2,Data!A:A,1)):INDEX(Data!B:B,MATCH(C2,Data!A:A,1)))
that sums the range: Data!B6639:B6665
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks