Try

=SUMPRODUCT((A1:A100=DATE(2008,1,9))*(B1:B100=TRUE ))

Adjust the date formula as needed.

HTH,
JP

On Jan 9, 12:37*pm, Jeannie wrote:
Hi,
I've been trying for 2 days to make this formula work. *I have a spreadsheet
that shows the employees that have been hired and the ones that have left the
company. *I need to count how many have arrived for each month.
Column E has the date and Column F has the status (True for arrivals and
False for departures).
I need to have a formula that would combine:
=COUNTIF(E3:E276, "TRUE")
and
=COUNTIF(E3:E276, "2007-01-*") (I'm not sure about the use of the wildcard
in a formula)
Any help would be greatly appreciated
Thanks
Jeanne