ignore error values in excel | Aggregate function |
in this video i will show how to ignore error values in excel using aggregate functin. this aggregate function will ignore all the cells having error values and sum all values with in the range and will not consider the values which have an error in the cell. it will ignore all errors like #DIV/0! #N/A #NAME? #REF
This video will cover the following topics:
1- ignore error values
2- aggregate function
3- shorts video
4- youtube shorts
5- sum values by ignore error values
6- #DIV/0!
7- #N/A
8- #NAME?
9- #REF
#shorts
#viralshorts
#ytshorts
#youtubeshorts
#shortsvideoviral
#exceltips
#exceltipsandtricks
#exceltipsandtricksinhindi
#foryou
#foryoushorts
#fyp
