Forum Discussion

AaronC92's avatar
AaronC92
Copper Contributor
Dec 04, 2020
Solved

Help with function COUNTIF

I am trying to count the cells in a column that contain a number value but only if another cell in the same row contains the specified text. (possibly using wrong function?) see below for example   ...
excel
Formulas and Functions
office 365
  • devyadav2008's avatar
    devyadav2008
    Dec 05, 2020

    AaronC92

     

    =+COUNTIFS(E2:E7,E11,F2:F7,"<>")

     

    please find attached screen shot

     

    Month 
    nov1
    dec1
    nov 
    dec 
    nov2
    dec2
      
      
      
    dec=+COUNTIFS(E2:E7,E11,F2:F7,"<>")

     

AaronC92's avatar
AaronC92
Copper Contributor
Dec 07, 2020

SergeiBaklan 

 

This is exactly what I needed! thank you

Resources