COUNTIF / AND functions

what if you have 3 columns to check?

with an array like

1 1 3
2 1 2
2 1 4
1 2 3
1 1 3

How do you count the number of "1 1 3" occurances?

Try a formula like

=SUMPRODUCT(--(A1:A5=1),--(B1:B5=1),--(C1:C5=3))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dlund" <dlund@discussions.microsoft.com> wrote in message
news:C7813106-D458-4D7F-A55A-9E01A251DFCA@microsoft.com...
> what if you have 3 columns to check?
>
> with an array like
>
> 1 1 3
> 2 1 2
> 2 1 4
> 1 2 3
> 1 1 3
>
> How do you count the number of "1 1 3" occurances?