Add and count
Add up numbers while skipping errors
=AGGREGATE(9,6,B2:B5)How it works in Excel
- 9 tells it to SUM.
- 6 tells it to ignore errors.
- 1 averages and 4 finds the maximum.
- Fix the errors too, if you can.
The idea in general
It adds what it can, and steps around the broken cells.
What I assumed
- Your numbers are in B2:B5.
Check the result on your own data before relying on it.