I would like to be able to count symbols in a column, even if there is an "#Invalid Data Type" error in one or more of the cells in that column. Will the =IFERROR formula help me?
Here's what I'm working on:
I am trying to determine whether or not a project has been completed early, on time, or late based on the date it was requested to be complete and the actual completion date. I have assigned symbols in a "P STAT" column... green symbol as early, yellow is on time, and red is late. If the project is not yet completed, the cell returns an #INVALID DATA TYPE error and because that error is present in the P STAT column, the entire column will not count the rest of the symbols. I have been manually deleting the error cells, then filling them in once that project date is complete, however, that's a lot of manual maintenance. I'd like a solution to disguise the error message with another symbol, or return a value that will allow the column to be counted... this is what I was thinking:
=IF(DATEONLY([Install Request On/Before]49) = DATEONLY([Production Complete Date]49), "Yellow", IF(DATEONLY([Install Request On/Before]49) < DATEONLY([Production Complete Date]49), "Red", IF(DATEONLY([Install Request On/Before]49) > DATEONLY([Production Complete Date]49), "Green", IFERROR([P STAT]:[P STAT]49), "Blue")))
Am I on the right track? This particular formula is not working, but I wasn't sure if this was the right way to accomplish what I am looking to accomplish. Any advice on this would be great appreciated, thank you!
