Formula required

[Anton1983]

If B3 contains text and F3 is blank, I want F3 to be counted. Could I have a formula that enables this?

 

[gaz_chops]

Try

=COUNTIFS(B3,"*",F3,"")

 

[Anton1983]

B3 contains a date, which the formula doesn't seem to like? Does it need tweaking?

 

[gaz_chops]

You said it contains text, so it checked for text!

What can actually appear in B3 or F3?

 

[Anton1983]

The 'B' column contains dates, and the 'F' column contains TRUE or FALSE. We only want to count the number of blank cells in column 'F' where there is also a date in 'B'.

I thought dates counted as text, so sorry for the confusion!

 

[gaz_chops]

Try

=SUMPRODUCT((ISNUMBER(B3))*(ISBLANK(F3)))

A date in Excel is stored as a number.

 

[Anton1983]

That worked perfectly, thank you!

I'll make a note of the date is a number thing too.

 

[gaz_chops]

You're welcome.

1/1/1900 is stored as a 1 in Excel, all dates are counted from this date, hours & mins are stored as a fraction of a day.

 

[Fluff]

Another option
=COUNTIFS(B:B,"<>",F:F,"")