Forum Discussion

Cynthia Sullivan's avatar
Cynthia Sullivan
Copper Contributor
May 29, 2020

Trouble with a formula in EXCEL

I am attempting to search a sheet with three particular columns of interest:  and I want to count up the number of instances that match … the last check is for a blank cell, and I can not see to get ...
Excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    May 29, 2020

    by typing "isblank" it is checking if the cell contents say that text. Try using "" instead.

     

    BTW you do know that countifs treats those conditions with an AND logic and therefore all those conditions must be true and not OR.  I think that is what you want but wanted to mention it.

Cynthia Sullivan's avatar
Cynthia Sullivan
Copper Contributor

mtarler 

 

Still gives me a 0 answer … and that is not correct

 

mtarler's avatar
mtarler
Silver Contributor
May 29, 2020
maybe attach the sheet.
to debug I would check each condition individually to make sure it is pointing to the correct range and values. Also, are cells in col F blank or have spaces?

Resources