I need to know how to count all of the '1's in a column, but i only want them to be counted if another column (same row) is blank.
I know how to count the '1's if the other column has text in it, but i need to know the formula for the other way around.
The formula i have been using for counting with non-blank columns is =SUMPRODUCT(--(D2:D52=1),--(F2:F52<>""))