Formula countif

TVP ALAN

Hallo

Can you check what i need to do to change the formula .

Example

When i use formul

=COUNTIF([Column2]:[Column2]; [Column2]@row)

Then when cell in location is emty ( which is always empty ) then it is i always get total numer of cels … Can someone help me to make formul to make sure this doesnt count emty field into result… thanks

Paul Newcome

Try this instead:

=IF([Column2]@row <> ""; COUNTIFS([Column2]:[Column2]; @cell = [Column2]@row))

Paul Newcome

Try this instead:

=IF([Column2]@row <> ""; COUNTIFS([Column2]:[Column2]; @cell = [Column2]@row))

TVP ALAN

Thank working thanks

Paul Newcome

Happy to help. 👍️