To calculate sum of a range which includes the errors , use the following formula to ignore all the errors you have in the same range.
#excel #microsoftexcel #exceltutorial #exceltutorials #exceltutor #tutorialexcel #microsofttrainingexcel #microsoftexceltips #excelformulas #excelvba #exceltips #exceltipsandtricks #excelvideo #excelshorcuts
...
https://www.youtube.com/watch?v=6qHqqvUDPrs