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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

snaik - 05 Mar 2008 13:50 GMT

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?

Reply to this Message

Gary''s Student - 05 Mar 2008 14:08 GMT

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

Signature

Gary''s Student - gsnu200771

Reply to this Message

Barb Reinhardt - 05 Mar 2008 14:09 GMT

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.

Signature

HTH,
Barb Reinhardt

> 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?

Reply to this Message

David Biddulph - 05 Mar 2008 14:14 GMT

"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).
--
David Biddulph

>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?

Reply to this Message

Bob Phillips - 05 Mar 2008 15:11 GMT

Try

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

adjust the ranges to suit

Signature

---
HTH

Bob

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

>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?

Reply to this Message