Cant sum columns with formulas?

Hello everyone,

I have asked a few coworkers for help and none of us can find a quick answer to this...

I have a worksheet with columns that derive totals based on different formulas such as =IF(AND(E10="CV",F10=3),"1","0").

We can't get the columns to sum up at the bottom with =sum(range) it just doesn't work. It does work if we do =+cell+cell+cell, which is terribly tedious...

Can someone PLEASE tell me how to sum the columns easily?

Any help is appreciated!

Remove double-quotes around numbers, to wit:

=IF(AND(E10="CV",F10=3),1,0)

Thank you!!!