I am using the counta function to count how many cells have data in them but blank cells are being counted. If I manually do "clear contents" on any of the cells then they are not counted. This is a large spreadsheet so I'm looking for a faster way to do a global "clear contents". Any suggestions?