I have a column of calculated values (running averages). Actually I have many columns containing running averages.

For each of the running averages (columns) I am trying to calculate the MIN, MAX, AVERAGE and find where the MIN and MAX are.

This worked fine for all the columns of averages but one. In this one column I get the #DIV/0! error for every single value (MAX, MIN, AVG, and INDEX)!

How can I get that error for a function that doesn't require any division? It worked and gave values for every column but one, and the column it didn't work for, is really no different than the others. I pasted the equations across all columns and the one in the middle shows only #DIV/0!. It seems like a glitch. How do I fix this?

Thanks, it is quite frustrating.