COUNTIF Formula not returning correct values...

paigemcd

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?

Paul Newcome

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?

Corey W.

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.

paigemcd

@Corey W. thanks for looking, unfortunately it does cover the entire range, so I am stumped.

Paul Newcome

How exactly is the source data being populated?

Corey W.

Could you try LEN([Processing Group]@row).

Then compare the length of all the "Col B" strings?

paigemcd

Paul Newcome The source sheet is a not being populated from anywhere/anything. It was uploaded from a CSV originally

Paul Newcome

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?