Hi,
Try this (example for Person Nr.1, Category "A" and Month February):
=SUMPRODUCT((B1:B1000=1)*(C1:C1000="A")*(MONAT(E1: E1000)=2))


"Ghalmaraz" wrote:

Hi,

I need a formula to count the number events that occur BY a certain person
(in column B, with each person numbered from 1-22), IN a certain category (in
column C, with the events coded as A,B,C and D) AND in a certain month (in
column E, date format ??/??/????)

Any ideas?