IF(COUNTIF(

[Guest]

I have the following formula in b1

=IF(A10="","",COUNTIF('Data Entry'!$K$5:$K$10005,'Leg list'!A10)

Works fine when there is data in A10, but when the data is missing say from A8000 to A10005, it gives the count of all blank cells in the range (2005)for every cell between 8000 & 10005, I need these to be blank

Any ideas
Thanks agai

Geron

 

[Harlan Grove]

I have the following formula in b10

=IF(A10="","",COUNTIF('Data Entry'!$K$5:$K$10005,'Leg list'!A10))

...

First, does this mean this formula is in 'Leg list'!B10? In other words, do A10
and 'Leg list'!A10 refer to the same cell? If not, that could explain why the
formula above returns a number when A10 (which wouldn't be 'Leg list'!A10) were
something other than "" but 'Leg list'!A10 could be "".

 

[Guest]

Thanks for the reply Harlan

The Data Entry page has many duplicates, so in the page "Leg list" I have filtered out all duplicates, copied and pasted only values. A10 has the formula: =Unique entries!A10.

Cells A3:A9 all give the correct answer, but A10 gives me a count of all the blanks

Also I've just tested the cell A10 and it is text, although there isn't any data in the cell

Still stumpe

Gero

 

[Harlan Grove]

Also I've just tested the cell A10 and it is text, although there
isn't any data in the cell.

If Excel believes a cell contains text, then it contains text whether you
can see any contents or not. A string of space characters would be one
example, and it wouldn't be equal to "". You many need to use

TRIM(A10)=""