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,Ma...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Nov 25, 2023

    MiM_87 

    Perhaps

     

    =IF(Main!E3="", "", COUNTIF(Main!$E$3:$E$158, Main!E3))

HansVogelaar's avatar
HansVogelaar
MVP
Nov 25, 2023

MiM_87 

Perhaps

 

=IF(Main!E3="", "", COUNTIF(Main!$E$3:$E$158, Main!E3))

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