counting with three conditions
 

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!

counting with three conditions
 

=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!

counting with three conditions
 

You're awsome. Thanks

"Lucas Soler" wrote:

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!