Thanks! Works great. I was suspecting syntax but as usual, the help files
didn't help

"DOR" wrote:

It should work properly if you are looking for an equal condition.
However, if you are looking for ,<,or <, then you need something like

=SUMIF(CritRange,""&A1,SumRange)

where your criterion value is in A1, if you are looking for an
inequality. You put whatever inequality sign you need between the
quotes.

HTH

DOR