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. :)
