If you have a minute -
Can you give a quick explanation of how this works? What does the " -- "
mean in a formula? I don't remember seeing it.
thanks for your time
dp

"T. Valko" wrote:

Sometimes we overlook the easiest solution!

=SUMPRODUCT(--(A1:A100=50),--(B1:B100=50),--(C1:C100=50))

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Here's another one:

=SUMPRODUCT(--(MMULT(--(A1:C100=50),{1;1;1})=3))

Note that using this the range is limited to no more that 5460 rows

--
Biff
Microsoft Excel MVP


"BASCRUMMY" wrote in message
...
I am attempting to count the number of times a specific value range occurs
in
a row throughout a large spreadsheet. For example, I have three values
in
multipe rows:
A1=10, B1=20, C1=30,
A2=20, B2=10, C2=30.
A3=50, B3=50, C3=50
I want to create a formula that will allow me to count the number of rows
that contain 50,50,50 within a large area.