| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum of cells
I want to add cell C12 and C15 and B19 only if either C12 and C15 have a
number in them. Otherwise i want the cell left blank. How can i do this? Thanks! Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Sum of cells
Do you mean:
If C12 *and* C15 If C12 *or* C15 Here's something for both: *and* =IF(COUNT(C12,C15)=2,SUM(C12,C15,C19),"") *or* =IF(COUNT(C12,C15)=1,SUM(C12,C15,C19),"") Biff "EG" wrote in message ... I want to add cell C12 and C15 and B19 only if either C12 and C15 have a number in them. Otherwise i want the cell left blank. How can i do this? Thanks! Eric |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Sum of cells
=IF(OR(ISNUMBER(C12),ISNUMBER(C15)),C12+C15+B19,"" )
-- David Biddulph "EG" wrote in message ... I want to add cell C12 and C15 and B19 only if either C12 and C15 have a number in them. Otherwise i want the cell left blank. How can i do this? Thanks! Eric |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Sum of cells
Let's change that *or* formula to:
=IF(COUNT(C12,C15)0,SUM(C12,C15,C19),"") Biff "T. Valko" wrote in message ... Do you mean: If C12 *and* C15 If C12 *or* C15 Here's something for both: *and* =IF(COUNT(C12,C15)=2,SUM(C12,C15,C19),"") *or* =IF(COUNT(C12,C15)=1,SUM(C12,C15,C19),"") Biff "EG" wrote in message ... I want to add cell C12 and C15 and B19 only if either C12 and C15 have a number in them. Otherwise i want the cell left blank. How can i do this? Thanks! Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format for cells. | New Users to Excel | |||
| conditional formats for cells | Excel Worksheet Functions | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
| conditional minimum value of various cells? | Excel Worksheet Functions | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Linear Mode
