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