#spill error

[Cowboy95]

Please help me find the flaw in this formula: =IFERROR((A2:A4)-(A5:A7)/A1,"")

Intention is to add A2:A4, then subtract the sum of A5:A7 and divide by A1 to return a percentage or a blank. This is giving me a #spill error.

Thanks in advance!

 

[Candyman8019]

=IFERROR((sum(A2:A4)-sum(A5:A7))/A1,"")

 

[Cowboy95]

Thanks Candyman