My sumif answer is in a alphanumeric field. My response comes bac.

B

buyer1

I am trying to receive information from a field that has alphanumeric data.
When I use the "sumif" formula my response comes back "0". I have tried to
same the alphanumber data as text but that does not help. I am using Excel
2002.
 
6

'69 Camaro

Hi.

You've mistakenly posted your question in the Microsoft Access (the database
application that's part of MS Office Professional) newsgroup. Please post
your question in a more appropriate newsgroup.

HTH.

Gunny
 
L

Larry Linson

"buyer1" wrote
I am trying to receive information
from a field that has alphanumeric data.
When I use the "sumif" formula my
response comes back "0". I have tried to
same the alphanumber data as text but
that does not help. I am using Excel
2002.
Click to expand...

Better Excel answers are likely to be obtained by using a newsgroup devoted
to Excel. This one is devoted to Microsoft Access database software.

Larry Linson
Microsoft Access MVP
 
Top