Sum Query - Issue with auto sum

[dbashby1969]

I have a simple sheet, a dictionary that after the user has entered the definition will be awarded 1 point.

Column A holds the word
Column B will hold the definition
Col C holds =IF(ISBLANK(B3),"No","Yes")
Col D holds =IF(ISBLANK(B3),"0","1")

Column D will hold the points so at the bottom I want to auto calculate the points awarded but no matter what when I use the =SUM(D3:D31) I still get Zero in the total. Can someone advise why this what should be simple task is not working.

Thanks

 

[Weazel]

try removing the quotes from around the 1 and 0

 

[dbashby1969]

Thanks for that. I knew it was a simple solution but just couldn't get my head round it.