counting with three conditions

[Lucas Soler]

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!

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy


"Lucas Soler" <[email protected]> wrote in message
news:[email protected]...
> 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!

[Lucas Soler]

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!