Forum Discussion

MiM_87's avatar
MiM_87
Copper Contributor
Nov 25, 2023
Solved

COUNTIF formula ignoring empty and zeroes

Hi,

 

I am trying to self-learn, also I am not English and it is possible for my "program language" to be wrong, please excuse me.

This is the formula which I am using =COUNTIF(Main!$E$3:$E$158,Main!E3)

I would like to know (in column H) how many times my product code is repeated in column E, unfortunately when the cell is empty, it is counted too, so I have 109 empty cells in this column and this number is showing. I would like this when the cell is empty or 0, to not be counted, and column H to stay empty. I hope this makes some sense.

 

Thank you and kind regards

Milena

2 Replies

    • MiM_87's avatar
      MiM_87
      Copper Contributor
      Thank you very much, was very helpful 🙂

Resources