Whats up with the square bracked and the double double quotes?

=SUMPRODUCT(--(A2:A7="A"),--(B2:B7="BOX017"),--(C2:C7="S1"))

--
Regards,
Tom Ogilvy



"Ardus Petus" wrote:

=SUMPRODUCT(--(A2:A7]=""A""),--(B2:B7]=""BOX017""),--(C2:C7]=""S1""))

HTH
--
AP

"carl" a écrit dans le message de
...
My data comes in like this:

Type ID Group
B BOX017 VR
A BOX017 S1
B BOX017 S1
A BOX234 S1
B BOX017 S1
B BOX017 GK




I am trying to find a formula for cell B2 below that will count the number
of occurances of Type=A, ID=BOX017, and Group=S1.

ID Type A
BOX017 1

Thank you in advance.