Hi,

You were very close, try this

=IF($C147<J$3,$D147,0)+IF($E147<J$3,$F147,0)+IF($G 147<J$3,$H147,0)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mark D" wrote:

Evening everyone

I am sure this is simple but it's late and I'm very tired.

I have the following IF statment but I need all three to be added together -
the sum of D147,F147 & H147

=IF($C147<J$3,$D147,"")+IF($E147<J$3,$F147,"")+IF( $G147<J$3,$H147,"")

All I am getting is a VALUE come up.

Thanks