It is certainly not typical having a different size of the range you want
have evaluated A1:A30 and the sum range C1:C75, besides it is useless since
you can't get it to sum beyond C30 anyway. Nevertheless I tested with a
criteria string that had 100 characters without any problems


--
Regards,

Peo Sjoblom



"BAC" wrote in message
...
Thanx Dave, but

No, strings in column A may recur multiple times in Col C.

This is "typical" use for SUMIF() i.e. to combine multiple occurences
into
1 - no?

BAC

"Dave Peterson" wrote:

Could it be that the ranges don't match: 1:30 in column A vs 1:75 in
column C?



BAC wrote:

XP Pro/Office 2003 PRO

Is there a limit on the number of characters that can be used in the
criteria section of a SUMIF()/COUNTIF() function?

Columns A & B consists of strings with a length of 30 to 50 characters.

I get incorrect results when I try to SUMIF($A$1:$A$30, "=" & B2,
$C$1:$C$75) (This formula is copied down so B2 becomes B3;B4;B5...). Is
this
a SUMIF limit problem or do I need to look elsewhere for the weird
results
I'm getting?

TIA
BAC

--

Dave Peterson