View Single Post
  #4   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

carl wrote:
Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
#N/A ?

Thank you in advance


=SUMIF(A2:B2,"<#N/A")