Karl,

I did not look at your attachment, but if you have a list of dates, then you can use a formula like
this...

Array enter (enter using Ctrl-Shift-Enter)

=SUM(IF(RANK(A2:A15,A2:A15)<4,B2:B15,0))

Where dates are in column A, and the numbers to be summed are in column B.

HTH,
Bernie
MS Excel MVP


"karl41" wrote in message
...

Hi all
Having a problem in excel which is driving me mad! I have a list of
data and i want to create a conditional sumif formula where the sum is
taken only of the last three entries. For our league analysis i look at
a team results history for the last three games by adding up the goals
for and against for last three matches. I want to write a formula
which would look through the list and automatically add the goals for
the last three entries for a team. This cant be done with a traditional
sumif formula as the range is specified and this may include the last
four or five games for a team whilst three for another.

Greatly appreciated,
Karl


--
karl41
------------------------------------------------------------------------
karl41's Profile: http://www.excelforum.com/member.php...o&userid=37473
View this thread: http://www.excelforum.com/showthread...hreadid=571341