View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark D[_2_] Mark D[_2_] is offline
external usenet poster
 
Posts: 52
Default Multiple IF statment help

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