H
hostonthecoast
I've been reading through previous threads and can't find the solution to my
problem. I need to count the number of cells that are "not blank" in column G
after columns C and D meet the criteria ie:
=SUM(IF('ALL WO List'!$C$1:$C$11716="FBR",1)*(IF('ALL WO
List'!$D$1:$D$11716="MECH",1)*(IF('ALL WO List'!$G$1:$G$11716="not
blank",1))))
Wild cards (?*) and "counta" don't seem to work....what am I missing?
problem. I need to count the number of cells that are "not blank" in column G
after columns C and D meet the criteria ie:
=SUM(IF('ALL WO List'!$C$1:$C$11716="FBR",1)*(IF('ALL WO
List'!$D$1:$D$11716="MECH",1)*(IF('ALL WO List'!$G$1:$G$11716="not
blank",1))))
Wild cards (?*) and "counta" don't seem to work....what am I missing?