I am familiar with the formula to count the number of occurrences of a
certain item i.e.:

=COUNTIF(Support!$B:$B,"bl-565*")

Which would filter out the number of products called "bl-565" for
example.

Say, for example if I then want to further filter the number of
bl-565's by problem type, and normally problem type is found by using:

=COUNTIF(Support!$G:$G,A22)-1

Can I combine the two formulas using some kind of logic statement?
i.e.:

=COUNTIF ((Support!$B:$B,"bl-565*") AND (Support!$G:$G,A22)-1)

I imagine this is possible, it's just a matter of getting syntax right
but so far I have been unsuccessful.


--
TISSMOD
------------------------------------------------------------------------
TISSMOD's Profile: http://www.excelforum.com/member.php...o&userid=30830
View this thread: http://www.excelforum.com/showthread...hreadid=504931