Counting blank cells

[Morfi]

I have a column in my spreadsheet that contains dates of mail coming in and another that contains dates of responses to this mail. I want to use a formula to count how many letters coming in have not been responded to i.e.

Column A = date of receipt
Column B = date of response


I know this would invlove counting the blanks in column B but I only want to count the blanks in that column if there is a date entered in column A.

Thanks

 

[gehusi]

{=sumproduct(if(A1:A10<>"",1,0),if(B1:B10="",1,0))}

Entered via CTRL+SHIFT+ENTER. Adjust your range to suit your needs.

 

[T. Valko]

I have a column in my spreadsheet that contains dates of mail coming in and another that contains dates of responses to this mail. I want to use a formula to count how many letters coming in have not been responded to i.e.

Column A = date of receipt
Column B = date of response


I know this would invlove counting the blanks in column B but I only want to count the blanks in that column if there is a date entered in column A.

Thanks

One way...

=SUMPRODUCT(--(A2:A10<>""),--(B2:B10=""))

Assumes A2:A10 will contain dates only.

 

[bosco_yip]

Enter formula :

=SUMPRODUCT((A2:A1000<>"")*(B2:B1000=""))

Regards