jcountry22
New Member
- Joined
- Aug 15, 2014
- Messages
- 36
I'm trying to use a formula to count cells in a specific column that start with the letter "P".
In column "A" there is a pivot table with data for the Year, Month, and subsequent order numbers within each month.
each order number starts with the letter "P" and is 5-digits.
using a normal count formula ends up counting the months & year(s). I only want it to count the # of orders.
formula i'm using is =COUNTA(A5:A244), which is counting 240.
In column "A" there is a pivot table with data for the Year, Month, and subsequent order numbers within each month.
each order number starts with the letter "P" and is 5-digits.
using a normal count formula ends up counting the months & year(s). I only want it to count the # of orders.
formula i'm using is =COUNTA(A5:A244), which is counting 240.
