=If formula giving a false return

I'm not really sure I'm following what you need...

Look here, is this it?

(I've entered few names manually in column G to better describe solution)...

Also, I'm not sure your thread name is suitable and you have lot of posts at your back...

Your post title should describe your problem

zbor,

That does not quite cover the problem. All entries are not made at the same time (see new example). The entries are made as games are completed, not necessarly in the order listed on the "Scores" sheet so their are likely to be temporary gaps in the data. They will be filled in as the tournament progresses and more games are played. I was looking for something that will give an accurate record at any point in time.

I apoloigize if the title is less than clear. I was not sure what to call it.

JIm O

OK, so now this is formula that doesn't work?

Can you give desired output (probably few more inputs and all outputs for them).

I was looking for a list of each individual who won and then I can sum the winnings for each person.

Column "G" is a list of each game and the winners, I am looking to sumarize that list, even if their are gaps in the data.

JIm O

maybe this:

zbor,

I think that is the answer. Thank you very much for your time with this. You have made an old man very happy.

Jim O