=sumproduct(--(A1:A200=1),--(B1:B200=2),--(C1:C200=3))

--
Regards,
Tom Ogilvy


"Lucas Soler" wrote in message
...
I have columns A, B, and C
I want to count the number of rows that all three columns equal specific
values. I was able to use the sumproduct function for two columns, but
can't
seem to get this to work for more conditions. Thanks!