it worked adapted formula now doesn't please help

i am setting up a spreadsheet for my bowling league sec. i have everything setup except for counting total points won. using formula =IF((D4+C4)>(L4+M4),"TRUE", IF((D4+C4)=(L4+M4), "HALF","FALSE")) to figure out if individual won, lost or tied. then i have =COUNTIF(D16:D20,"TRUE") to count the points won. it worked until i modified the first formula to calculate half's. how do i fix this?

Hi worthingto and welcome to the forum,
Change the first formula to:

Please Login or Register  to view this content.

then make the second formula

Please Login or Register  to view this content.

The idea here is instead of making a Win = True, you will make it a 1. Also a tie will be = .5.

I hope this makes sense and helps. If not you need to attach your workbook so we can see what is happening. You can do that by clicking on "Go Advanced" and then the Paper Clip Icon above the advanced message area.

If you are satisfied with the solution(s) provided, please mark your thread as Solved. In future also take more care with Thread Titles

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save