The longer version works: =SUMPRODUCT(('Q1 '!E13:E137="Calibrated")* ( ('Q1
'!G13:G137="74532")
+ ('Q1 '!G13:G137=74532) ) )

But the shorter formula gives me #VALUE result!

Tmt

"Lars-Ã…ke Aspelin" wrote:

On Tue, 9 Feb 2010 13:11:01 -0800, Jim Thomlinson
wrote:

Most liketly the 74532 is causing you the problem. You are looking for text
occurances. If the values in the cells are numbers then they will not be
found. Try formatting the column with a decimal. The text entries will stay
the same but the numbers will include the decimal.

Try this formula to get an or condition as a way around it...
=SUMPRODUCT(('Q1 '!E13:E137="Calibrated")*('Q1 '!G13:G137="74532")+('Q1
'!G13:G137=74532))

I think there is a couple of parenthesis missing if you just want to
count the Calibrated occurances of 74532.

This is how I should write it:

=SUMPRODUCT(('Q1 '!E13:E137="Calibrated")* ( ('Q1 '!G13:G137="74532")
+ ('Q1 '!G13:G137=74532) ) )

Here is a shorter formula to achieve the same result:

=SUMPRODUCT(('Q1'!E13:E137="Calibrated")*('Q1 '!G13:G137+0=74532))

The +0 makes a number of the content in the G column even if it is
text as long at is looks like a number. Thereby you can compare it to
a number.

Hope this helps / Lars-Ã…ke
.