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

PS. royUK, sorry about that I hadn't clued onto what type of poll I was adding. Apologies...

Hi,

I have used that already, but perhaps what I neglected to say is that between the 'valid' scores that I'm wanting to test, there is other information (generally numbers).

so the row might read (* for valid numbers to test)

100000 3* -150 120000 4* -450 125000 4* -125

Result would be 4 in this case. Any variations on the suggested formula?