If there is a list of numbers, it is straightforward to find their SUM. But sometimes, we encounter a situation where the numbers in cells are intermittent. This is called sporadic behavior in Excel.