Forum Discussion
Solved
Unable to Figure Out Reason For An Error
The cells Y15, Y16, Y22 and Y23 are currently displaying errors, and I cannot figure out why they are. I have reformatted the formulas, but I am still unable to figure out why they do not work.
jkuchman I noticed the "@" towards the end of the formula in Y15 and that made me wonder what you want to do. Removed it and it resulted in a #SPILL error. Then I just spelled out the entire formula below the table on the Hitters sheet, in order to undertand what's going on. I believe you need to replace the part with the "@" by this:
SUM(Hitters!AA11:AA24)/SUM(Hitters!J11:J24)... and then it will work. Deleting data from the Hitters list will now not affect the outcome in Y15. See attached.
The last parts of the formulae in Y15, Y22 and Y23 are the cause the #VALUE! error.
Hitters!$AA$11/Hitters!$J$11Both cells have a "hyphen", so you are trying to divide "-" by "-".
Y16 calls for Y22 (above), thus returns the same error.