View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mstrausz mstrausz is offline
external usenet poster
 
Posts: 1
Default How do I Auto Sum numeric results from an IF/THEN equation?

I have an if then statement that returns numeric results. I would like to be
able to sum up the list of results but Excel returns a " - ". I believe it
is because the sum tool ignores logical equations but there has to be a way
around it. Thanks for any help.