Need to stop my count If Formula Count Blanks from my main table.

[Leicester City Fox]

Hi There

I have a formula that work fine but when I drag the formula down the column it returns the same number (4987) as shown example below:

It takes this information from the main table 1 and I believe it counting the blank cells in this table.

=COUNTIF(table1[RefNo.],A3)



Column A Column B

RefNo. No records

1234 2

4321 4

Blank 4987

Blank 4987

Blank 4987

I don’t want it to show a result (4987 or any number) if column A is Blank and only to count once a RefNo. has been added.

I would be grateful for any ideas to make my formula work or suggestions.

Many Thanks & Stay Safe

The Leicester Fox

 

[Fluff]

How about

=if(a3="","",COUNTIF(table1[RefNo.],A3))

 

[Leicester City Fox]

How about

=if(a3="","",COUNTIF(table1[RefNo.],A3))

Hi Fluff

Afternoon

I am really grateful, I must of followed the wrong rabbit hole is was seeing signs to use "<>" for count if but your formula is a lot better and just what I needed.

Thanks again and stay safe

The Leicester Fox

 

[Fluff]

You're welcome & thanks for the feedback.