Conditional Sum of cells

[EG]

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

 

[T. Valko]

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

 

[David Biddulph]

=IF(OR(ISNUMBER(C12),ISNUMBER(C15)),C12+C15+B19,"")

 

[T. Valko]

Let's change that *or* formula to:

=IF(COUNT(C12,C15)>0,SUM(C12,C15,C19),"")

Biff