How to sum series of number with #n/a

Hi. Today I am gonna show you how to add accross numbers that has #n/a in it.

When you are using =sum formula for this series of number, it will definitely will return #n/a value.

Solving this is simple, you just have to use =sumif formula.

This formula means, we are summing up from C2 to C9 for whatever amount is not equal to #n/a.

In excel this sign '<>' means not equal to.

You can also apply this to sum only +ve amount or only -ve amount or whatever amount which is bigger than X as shown in below example which we are summing up amount more than 7.

Okay, that all for today then. Happy trying. :)