| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if statement
My formula in Column D should read =sum(d6+c7=d7) but if c7 is blank then i
want the answer to be blank in column D7 column C6 D6 5 10 c7 D7 0 leave blank.(not even a zero) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum if statement
You can make the cell look blank with:
=if(c7="",sum(d6,d7,c7)) or =if(c7="",d6+d7+c7) You don't need =sum() and the + signs. Kim Shelton at PDC wrote: My formula in Column D should read =sum(d6+c7=d7) but if c7 is blank then i want the answer to be blank in column D7 column C6 D6 5 10 c7 D7 0 leave blank.(not even a zero) -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum if statement
Still puts o in d7
if c7 is blank that I don't want the formula in d7 to calculate not even a zero any other ideas???? "Dave Peterson" wrote: You can make the cell look blank with: =if(c7="",sum(d6,d7,c7)) or =if(c7="",d6+d7+c7) You don't need =sum() and the + signs. Kim Shelton at PDC wrote: My formula in Column D should read =sum(d6+c7=d7) but if c7 is blank then i want the answer to be blank in column D7 column C6 D6 5 10 c7 D7 0 leave blank.(not even a zero) -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum if statement
Sorry, I had a couple of typos.
=if(c7="","",sum(d6,d7,c7)) or =if(c7="","",d6+d7+c7) Kim Shelton at PDC wrote: Still puts o in d7 if c7 is blank that I don't want the formula in d7 to calculate not even a zero any other ideas???? "Dave Peterson" wrote: You can make the cell look blank with: =if(c7="",sum(d6,d7,c7)) or =if(c7="",d6+d7+c7) You don't need =sum() and the + signs. Kim Shelton at PDC wrote: My formula in Column D should read =sum(d6+c7=d7) but if c7 is blank then i want the answer to be blank in column D7 column C6 D6 5 10 c7 D7 0 leave blank.(not even a zero) -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Need if Statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
