G
Gary Keramidas
for columns b and c, if b is blank and c > 1, i want the count for column c.
i tried these to no avail
=COUNT(IF(B3:B33="",C3:C3>1,C3:C33))
=SUMPRODUCT(B3:B33="")*(C3:C33>1)
i tried these to no avail
=COUNT(IF(B3:B33="",C3:C3>1,C3:C33))
=SUMPRODUCT(B3:B33="")*(C3:C33>1)