Thanks for the help, I was able to get it working for the max value, it wouldn't work for other functions for some reason. I realized that even with the false statement as 0, it would count it as zero instead of ignoring the cell. I just made the false statement be text and the formulas seem to be working.