row sum - 9 cells change values to 1 and add the "1"
Hi Dick,
C5 =5
C6 =9
D5 =SUM(C51,C61) ===== 2
---
Regards,
Norman
"Anvil22" wrote in message
...
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
|