Logic Test / Lookup Formula Help - Fantasy Football

Hi All,

First time poster, just trying to work out a wee problem in a spread sheet.

I have a series of data which relate to the points scored by certain players in a round (see sample spreadsheet).

The data appears in rows with non-adjacent columns (columns in between cannot be easily removed). There are at least 26 different instances of the data.

When a player does not play "dnp" is listed in the round score.

What's I'm after in a cell to the left is the last two valid rounds sum. In the case of the example file they should be both '8'.

I'm a bit stuck on how to do this and would be keen for any advice, help that anyone could possibly give.

VBA is an option, although I guess this might be the wrong forum. I've done things similar to this in the past using adjacent arrays, but not sure how to extend this knowledge. Will post if I solve it.

Cheers,
wazzap_nz