| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change default settings of "Save external links values" | Excel Discussion (Misc queries) | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| =IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Linear Mode
