Why is SUMIF returning #DIVIDE BY ZERO error?
I have written a simple SUMIF formula to sum the parent rows in the Sheet Summary of a budget sheet.
Formula is written as =SUMIF(Parent:Parent, 1, [Budget at Completion]:[Budget at Completion])
It is giving me a #DIVIDE BY ZERO error, and I cannot figure out why. I don't have division in my formula. The data is formatted to USD in both the sheet and the summary.
Any ideas? Image attached.
Help Article Resources
Check out the Formula Handbook template!