There's probably an easier and more elegant way to do it, but this works,
=SUM(INDIRECT(ADDRESS(MATCH(1000,A1:A1000)-2,1,4)&":"&ADDRESS(MATCH(1000,A1:A1000),1,4)))
Regards,
Alan.
"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