Hi Addatone,

Am Mon, 26 Aug 2013 23:10:28 +0100 schrieb Addatone:

I attached a copy of the file.

your attached file doesn't work. It gives an error when trying to open.

Try:
=COUNTIFS(Data!B2:B20,B18,Data!D2:D20,J16)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2