I am trying to loot at the values in a row of cells, chang them to 1 and add
the "1"
I have tried variations of the following.
c5=5, c6=9
if(c5)1,1,0, if(c6)1,1,0, sum(c5:c6)
individuallly the give me the correct results. 1. But the results I am
looking for should be 2.

Can anyone help with the formuls or tell me what I am doing incorrectly?

Thanks Dick