Last 5 Results (footie)

Hi
Try this formula in F13 (valid to H13)

Formula:

=SUMPRODUCT(--($A$5:$A$500=$F11)*($B$5:$B$500=F$12)*(ROW($A$5:$A$500)>=AGGREGATE(14,6,--ROW($A$5:$A$500)*($A$5:$A$500=$F11),5)))

where $F11 is "Home", F$12 is "Won" (not "Won ")
You can copy the formula to F19:H19

See the file

Thank you José Augusto this works a treat...... Thank you