am having trouble with a formula and thought I would see if you all have any
ideas.



I am doing a count of dates in Column D of a report, which also has blank
columns, and this formula gives me the correct data (number of dates listed
in the column):



=COUNTIF($D$8:$D$272,"<04/22/2009")



But€¦



I need to add additional criteria so I only get the count for €œBob Bugnand€�.
I have tried various ways to add this to the COUNTIF and cant get the
formula to work. What I need to add is€¦



($Q$8:$Q$272,€�Bob Bugnand€�)