Hi!

A1 = 11/29/2004
B1 = 7
C1 = W

Total points for the last n games (based on the date entered in A1 and the
value enterd in B1):

=SUM(OFFSET(D8,MATCH(A1,A$8:A$89,0)-1,,-B1))

Number of wins using the same criteria:

=COUNTIF(OFFSET(F8,MATCH(A1,A$8:A$89,0)-1,,-B1),C1)

Biff

"miller" wrote in
message ...

Anyway you can write a function for # of wins and total points that
does the same for the last 7 games.

So it would the end date + the 6 cells before it. From the data above:

The end is 11/29/2004 the function would come back:

1 for wins and 592 for total points scored.


--
miller
------------------------------------------------------------------------
miller's Profile:
http://www.excelforum.com/member.php...fo&userid=4238
View this thread: http://www.excelforum.com/showthread...hreadid=474550