I want to subtract 2 numbers in 2 different cells but ignore the #n/a. Similar to a summing function like this
SUMIF(C13:D13,"<>#N/A"). I am looking for an equivalent formula.
Many thanks.
I want to subtract 2 numbers in 2 different cells but ignore the #n/a. Similar to a summing function like this
SUMIF(C13:D13,"<>#N/A"). I am looking for an equivalent formula.
Many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks