Why SUMIF functionality doesn't work for data copied from .csv fil

[snaik]

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?

 

[Gary''s Student]

The copied data included blanks or other hidden characters that your manually
typed data did not include.

 

[Barb Reinhardt]

Is all of the data seen as numeric? In a helper column, put this =ISNUMBER(A1)

You should see TRUE for all of them if it's a number.

 

[David Biddulph]

"It didn't work" isn't a very useful description of the problem. If you
want help solving it, it might be worth telling us what the formula is, what
the contents of the input cells are, what answer you got, and what answer
you expected.
Two possibilities are that in one version of your data there are spare
spaces or other non-printing characters, and/or that in one version you have
text and in another you have numbers. You can check whether your data
strings from the two entry methods have the same length by using =LEN(A2),
and you can check what sort of data by using =ISTEXT(A2) and =ISNUMBER(A2).

 

[Bob Phillips]

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)