Anonymous asked in Computers & InternetSoftware · 2 months ago

How to combine counta with countifs in excel / google sheets ?

I would like to count the total number of cells that meet these two criteria:

Column A with text and Column B with empty cells. So let’s say Column A says “hi” and column B is empty, the count would be 1 

Please help I can’t find help anywhere

2 Answers

  • 2 months ago


    Or for your example.


    Additionally, if you mean to count NON BLANK cells in column A, use this


  • i + i
    Lv 7
    2 months ago

    What you are trying to do is unclear. Are you 

    only wanting to count those items in A column 

    if the neighboring cell to that item is empty? 

    I would do it this way:  

    =COUNTIF(B1:B1000, "", A1:A1000)  

    The above says to count only the values in the 

    range A1:A1000, where the corresponding cells 

    in the range B1:B1000 are equal to "" (null).  

Still have questions? Get your answers by asking now.