Forum Discussion
AaronC92
Dec 04, 2020Copper Contributor
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 ...
- Dec 05, 2020
=+COUNTIFS(E2:E7,E11,F2:F7,"<>")
please find attached screen shot
Month nov 1 dec 1 nov dec nov 2 dec 2 dec =+COUNTIFS(E2:E7,E11,F2:F7,"<>")
SergeiBaklan
Dec 05, 2020Diamond Contributor
AaronC92
Dec 07, 2020Copper Contributor
- SergeiBaklanDec 07, 2020Diamond Contributor
AaronC92 , you are welcome