View Single Post
  #1   Report Post  
claytorm
 
Posts: n/a
Default IF to ignore #N/A


Hi,

I have a string of IF conditions, which I am combining with SUM. I want
to get the IF conditions to ignore any cells containg the error message
#N/A. How can I do this?

Thanks,
Bertie.


--
claytorm
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=398660