oh....!

thats so much easier!
lol...

thanks alot!

"JE McGimpsey" wrote:

Oops - I answered "were filled", rather than "greater than zero". For
the latter, one way:

=COUNTIF(B6:B8,"0")*15

In article ,
m4d Ir15h wrote:

What if I wanted to add a third item in the following formula?

=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

For istance, if it would include B6, B7, B8...? so for each cell that had a
value greater than zero would add $15.00 to a total?

In other words...

If 1 of the 3 cells were filled... then it would add $15.

If 2 of the 3 were filled, it would add $30.00...

and if all three were filled, then it would add $45.00?