Try

SUMPRODUCT(--(TRIM(A1:A100)="value"),B1:B100)

adjust the ranges to suit

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"snaik" wrote in message
...
I copied data from a ".csv" file to an excel and used the "SUMIF"
functionality. It didn't work. When I use the same formula to but manually
enter the data it worked. Can anybody explain why this is happening?