Thread
:
Suming 2 cells if 1 = #N/A
View Single Post
#
4
Aladin Akyurek
Posts: n/a
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")
Reply With Quote