Simple Division formula resulting in error and should not be
I am having an issue with a simple averaging formula providing an incorrect outcome. In the example above the dollar amount in the DATA column is a result of a SIMIF formula. Additionally the results in Column4 are the results of a COUNTIFS formula. In Column 6 is a simple average formula that I wrapped in an if statement. If Column4 is 0 then the formula should run and if not I should return "Count is 0". As you can see there are 3 rows showing "Count is 0" but only 1 row, the lowest in the screenshot, has a zero in it. Why would this not calculate properly?
I also tried a simpler formula in Column6. Formula is =Data@row / [Column4]@row. For rows where Column4 is a 1, I get a "Divde by Zero" error.
Help Article Resources
Check out the Formula Handbook template!