Sum for column H
I didn't see you answering this question, column H FY18 sum isn't zero, why???????
2 answers ( 0 marked as helpful)
Hello,
Do you want to share a screenshot of your workbook, please? There are two possiblities,
1) if the sum is 0.483E-7 or something similar -> this is a bug and you should not pay attention to it
2) if the sum is not 0 and is a larger number than 0.1, let's say, then this means you have made an error when working with the functions.
Best,
Ned
I have 0 for the first column following the instructions but I have numbers in both G and H. Not sure which part of the workbook you need a screenshot of but here are my totals. I checked to make sure all formulas were =-SUMIF except for Net Income rows. Not sure why it's not totaling 0 🤔 