CountIf Function

[Carlene]

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 can’t get the
formula to work. What I need to add is…



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

 

[Gary''s Student]

Any time you need more than one criteria, use =SUMPRODUCT()

=SUMPRODUCT(--($D$8:$D$272<39925),--($Q$8:$Q$272="Bob Bugnand"))

SUMPRODUCT is one of Excel's most powerful functions. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Stefi]

=SUMPRODUCT(--(D8272<DATE(2009,4,22)),--(O8:O272="Bob Bugnand"))
Regards,
Stefi

„Carlene†ezt írta:

 

[RonaldoOneNil]

=SUMPRODUCT(($D$8:$D$272<DATE(2009,4,22))*(($Q$8:$Q$272="Bob Bugnand")))