amberfreed
New Member
- Joined
- Mar 26, 2008
- Messages
- 19
Hello,
I have a list of data that is generated from a formula. The formula either returns a number or a " ". I need to get a count of the numbers in my list. However, all count formulas (Count, CountA, CountIf) include the cells that contain " " even though no number is in that cell. Is there anyway to get around this?
I am also having the exact same problem with a pivot table. The pivot table doesn't consider a cell blank or error if there is a formula returning "" in the data. Therefore, the pivot table generates a 0.
Thank you!!!![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have a list of data that is generated from a formula. The formula either returns a number or a " ". I need to get a count of the numbers in my list. However, all count formulas (Count, CountA, CountIf) include the cells that contain " " even though no number is in that cell. Is there anyway to get around this?
I am also having the exact same problem with a pivot table. The pivot table doesn't consider a cell blank or error if there is a formula returning "" in the data. Therefore, the pivot table generates a 0.
Thank you!!!