row sum - 9 cells change values to 1 and add the "1"
 

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

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

row sum - 9 cells change values to 1 and add the "1"
 

Hi Norm,
Thank you - IOt worked liek a charm. I was so straigh forward. I have to
make one modification. I needed the count to include (1), so I change you
suggestion to c5=1,
and it worked.

thanks a again.
Dick

"Norman Jones" wrote:

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