COUNTIF Formula not returning correct values...
I am using a helper sheet to create a dashboard and want to find how many of each value is in a certain column in the source sheet, and it is returning the incorrect values. There are values such as Col A, Col B, Systems, etc. In this example I show I am using =COUNTIF({BT Migration Master Sheet Range 2}, "Col B") and it returns the value of "6". But in the range below, you can already see there are more than 6. For Systems, it shows 0, when you can clearly see there are more than 0. There are thousands of rows, totaling to over 4000, so I know these numbers are incorrect. I'm referencing the correct range when choosing. Any tips?
Best Answer
-
Ok. Have you applied a filter to the source sheet? Have you checked that there are no hidden apostrophes or spaces that are not visible unless editing a cell?
Answers
-
Maybe check the range you selected in your cross sheet reference to be sure you selected the whole column instead of a range of specific cells? Otherwise, it looks fine.
-
@Corey W. thanks for looking, unfortunately it does cover the entire range, so I am stumped.
-
How exactly is the source data being populated?
-
Could you try LEN([Processing Group]@row).
Then compare the length of all the "Col B" strings?
-
Paul Newcome The source sheet is a not being populated from anywhere/anything. It was uploaded from a CSV originally
-
Ok. Have you applied a filter to the source sheet? Have you checked that there are no hidden apostrophes or spaces that are not visible unless editing a cell?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!