Excel Sum function ignore error

preview_player
Показать описание
Have you tried adding numbers in Excel where one of the numbers is an error? Here is a possible fix.You can also apply this fix with the average function.
Рекомендации по теме
Комментарии
Автор

This was just the solution I needed. Thank you for making this video.

ProfBoggs
Автор

Great fix! It's the only one I've found to fix my particular issue.

BrettLWadsworth
Автор

Another alternative is to do =iferror(value, value_if_error) an Example in this instance as per the video would be =iferror(D2/E2, "")

danielplatt
Автор

Thanks a million bro! Very straight forward and you saved my ass!

hsshin
Автор

great to identify errors but what if everything is showing as an error? Then everything goes blank and you have no data to calculate. How do I correct errors rather than omit them from the equation?

propertyworld
Автор

Omg, such a life saver video for my case; thousands thanks and appreciate to you ❤️❤️🥹

leofender
Автор

This was just the solution I needed. Thank you for making this video.

riyankayastha