Anat

I suspect the 'criteria' is seen as text. If these are 'numbers' then
enter a 1 in a spare cell and copy it.

Highlight your 'numbers' and take editPaste special...Values + Multiply.
This should kick Excel into recognising them

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Anat" wrote in message
...
I am using the sumif formula and noticed that it doesn't pick up all the
data. I tried using trim to clear out all spaces in the criteria but
still
no luck. It works when I go and write over the criteria any ideas?

Thanks,
Anat