I posted another question not to long ago that I was resolved, thanks to who
replied, however, now I've run into another problem.

I am entering data on a day to day basis, so I am getting the #N/A in the
cells that have functions and no data to process those functions. I am
trying to keep a running count of certain info as I go, but the #n/a is
obviously screwing up the count in those columns, is there a way to avoid
counting the #n/a cells until they're filled in??