I did some more troubleshooting on this problem I'm having. The problem is that I have 2 columns of calculated data that is adjacent to a list (data>>list>>create list) that appears when I click on the actual cell that contains the calculated data but shows a #VALUE error when I click on the data within the list. I have little green arrows appearing on every cell of calculated data cells. When I click on the arrow a drop down menu appears that says 'formula refers to empty cells'.
It is true that some of the cells that my calculated formula refers to contains empty cells but this problem still isn't making sense. Especially because this strange problem goes away if I hardcode values into the formula:
=IF(F53<>"",SUMPRODUCT(--($C$2:$C$5305=C53),--($F$2:$F$5305=F53),--($Y$2:$Y$5305=Y53)),"")
Column F is a numeric column that contains numbers, but does have some blank cells
Column C is also a numeric column with no blanks cells.
Column Y is a 'general' column that has no blank cells.
It is true that some of the cells that my calculated formula refers to contains empty cells but this problem still isn't making sense. Especially because this strange problem goes away if I hardcode values into the formula:
=IF(F53<>"",SUMPRODUCT(--($C$2:$C$5305=C53),--($F$2:$F$5305=F53),--($Y$2:$Y$5305=Y53)),"")
Column F is a numeric column that contains numbers, but does have some blank cells
Column C is also a numeric column with no blanks cells.
Column Y is a 'general' column that has no blank cells.