Microsoft Excel Formula

Question

Hello Microsoft Community,

I’m working on a formula in Excel,

Short story long I am setting up a s/sheet to record scores of a sports team, and I’m having trouble with a IF formula.

I have the following formula in cell D3 to add up what scores everyone gets

=SUM(H3:X3)

In cell E3 I have to manually input the oppositions score

So I have three outcomes they Won, Drew, Lost.

I have created

=IF(D3=E3,"DREW",IF(D3>E3,"WON","LOST")) which does the trick

But because I have all the cells already in all the columns for cells where a game has not yet played in cell

D3 the total shows 0

I wanted the W,D,L column to either be blank or have a different output for any game not yet played, I created the following, so rather than W,D,L it went blank

=IF(D3=E3,"T",IF(D3=0," ",IF(D3>E3,"W","L")))

Now oddly this works for the first 5 rows, but then stops working even though the formula is correct for all the cells

It doesn't have to be blank I just want it not to say W,D,L as the game has not yet been played

Thank you in advance

Answer 1

=IF(COUNTA(H8:X8)=0, "", SUM(H8:X8))

Answer 2

Hi HansV

That has worked perfectly, maybe I am being greedy now

Is there a formula I can add to Cell D8, so column D will also be blank if there are no scores added?

I currently have

=SUM(H8:X8)

to add up when scores are added, it would be tidier without all the zeroes below

Thank you again

Answer 3

How about

=IF(E3="", "", IF(D3=E3,"DREW",IF(D3>E3,"WON","LOST")))

or

=IF(E3="", "NOT PLAYED YET", IF(D3=E3,"DREW",IF(D3>E3,"WON","LOST")))

Answer 4

Hope this helps

The Pins against and Points scored would be manually entered

I was hoping for a way that "Drew" was not shown as the game has not been played yet

Answer 5

Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.