Use Sumif to complete the dataset.
In the FY 2018 after getting values through sum if and negating the net income values, the sum of values is not giving zero similar to 2016 and 2017.Its showing as 1.772. Can you please explain?
Hello,
Good to hear from you. Most likely this means that you've made a mistake while working. Is the number 1.772 or something like 1.772E-8?
Best,
Ned
The value i am getting is 1.772E-8.
Can you help me spot the mistake.
The mistake already has been exit in the original sheet. Pls review the video lecture screenshot 
the auto AVG and SUM with errors. Please explain
It is the same mistake in the video too. Any way you guys can help with that?
Hi,
I did the SUM() manually, =SUMA(H4:H108), and I got this: 0,000000001779199.
So it looks like there might be a rounding issue, but I would be grateful for Ned's explanation of this problem. Do we need to bother if we encounter this in our work?
Nonetheless, we did the exercise in the same way as the instructor.
Regards