indiansfan
New Member
- Joined
- May 19, 2006
- Messages
- 11
I have a pivot table with numbers in column A and blanks below. I was trying to write a countif formula but I am not able to pick up the blanks. e.g. =COUNTIF(A:A,"213B")
Sample data:
Column A Column B
123 123-0692
456 456-0274
456-0275
456-0276
654 654-0301
213B 213B-2045
213B-2046
So my answer should be 2 but all I can get for an answer is 1.
Thank you in advance!
Sample data:
Column A Column B
123 123-0692
456 456-0274
456-0275
456-0276
654 654-0301
213B 213B-2045
213B-2046
So my answer should be 2 but all I can get for an answer is 1.
Thank you in advance!