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