Excel Data Searching Help - Fantasy Sports

[wazzap_nz]

Hi All,

I have a (hopefully simple) problem trying to get some statistics out of some data.

I have a series of data stored in a large number of columns. Each 'set' of columns has the following data: # = round points or dnp if they didn't play, P# = price for that round and opp = opposition for that round = where # = round. The data is arranged on sets of three, for 26 distinct rounds,

What I'm trying to do is tally up the scores in columns to the right of all my base data. Each column to the right needs to display the average score a player has made against an opponent, In this sport not all opponents are played twice, only some. If a player had a "dnp" them I would like that score not to count, e.g they played BRO twice and scored 50 and "dnp". 50 would be thier average against the BRO.

I've experimented with nested if statements and playing with DGET. I was also suggested to try it with VBA, however I'm not 100% sure on VBA. I could also 'manually' do it but that would be a lot of columns I think. My sample sheet only has 17 players data in it. There are 500 odd in total.

I would appreciate any help from the gurus out there. Please reply if you need clarification.

Cheers,
Warren