How do I sum a row?

C

caro79

I am attempting to sum a row but instead of adding the figures together, the
cell shows the number strung together. For example, if the numbers to sum are
4, 5, 10, and 5 the cell shows 45105 instead of 24. The formula I am using is:

Raw Score: [Programs Supported Score]+[ACAT1Programs Supported Score]+[DX
Programs Supported Score]+[Other Priority Programs Supported Score]

How should I write it so that the answer is an actual sum rather than a
string of numbers?
 
K

KARL DEWEY

I bet that your fields are text datatype and not numeric. It is hard to do
math on 'X' & 'Y'.
Try this --
Raw Score: Nz([Programs Supported Score],0)+Nz([ACAT1Programs Supported
Score],0)+Nz([DX Programs Supported Score],0)+Nz([Other Priority Programs
Supported Score],0)
 
J

Jeff Boyce

Your question "how do I sum a row?" implies that you have a series of like
values. This is very common ... in a spreadsheet!

This is very UNCOMMON in a well-normalized relational database table.

You posted to a Microsoft Access-related newsgroup ... is your question
about using Microsoft Access? If it is, you may want to reconsider how your
data is structured as a first next step.

Why, you ask? Because Access expects well-normalized data, and both you and
Access will have to work overtime to overcome 'sheet data.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

caro79

Unfortunately, that did not fix the problem. I still get the stringed
together number, just as I did with the original formula. I checked to make
sure everything was numeric and not text, and all I see are numeric fields.
Do you happen to have any other suggestions?
Many thanks!

KARL DEWEY said:
I bet that your fields are text datatype and not numeric. It is hard to do
math on 'X' & 'Y'.
Try this --
Raw Score: Nz([Programs Supported Score],0)+Nz([ACAT1Programs Supported
Score],0)+Nz([DX Programs Supported Score],0)+Nz([Other Priority Programs
Supported Score],0)

--
Build a little, test a little.


caro79 said:
I am attempting to sum a row but instead of adding the figures together, the
cell shows the number strung together. For example, if the numbers to sum are
4, 5, 10, and 5 the cell shows 45105 instead of 24. The formula I am using is:

Raw Score: [Programs Supported Score]+[ACAT1Programs Supported Score]+[DX
Programs Supported Score]+[Other Priority Programs Supported Score]

How should I write it so that the answer is an actual sum rather than a
string of numbers?
Click to expand...
Click to expand...
 
K

KARL DEWEY

Try this --
Raw Score: Nz(Val[Programs Supported Score]),0)+Nz(Val([ACAT1Programs
Supported Score]),0)+Nz(Val([DX Programs Supported Score]),0)+Nz(Val([Other
Priority Programs Supported Score]),0)

--
Build a little, test a little.


caro79 said:
Unfortunately, that did not fix the problem. I still get the stringed
together number, just as I did with the original formula. I checked to make
sure everything was numeric and not text, and all I see are numeric fields.
Do you happen to have any other suggestions?
Many thanks!

KARL DEWEY said:
I bet that your fields are text datatype and not numeric. It is hard to do
math on 'X' & 'Y'.
Try this --
Raw Score: Nz([Programs Supported Score],0)+Nz([ACAT1Programs Supported
Score],0)+Nz([DX Programs Supported Score],0)+Nz([Other Priority Programs
Supported Score],0)

--
Build a little, test a little.


caro79 said:
I am attempting to sum a row but instead of adding the figures together, the
cell shows the number strung together. For example, if the numbers to sum are
4, 5, 10, and 5 the cell shows 45105 instead of 24. The formula I am using is:

Raw Score: [Programs Supported Score]+[ACAT1Programs Supported Score]+[DX
Programs Supported Score]+[Other Priority Programs Supported Score]

How should I write it so that the answer is an actual sum rather than a
string of numbers?
Click to expand...
Click to expand...
Click to expand...
 
C

caro79

So maybe it all wasn't numeric fields. I fixed the problem, the new formula
is:
Raw Score: Nz(Val([Programs Supported Score]),0)+Nz(Val([ACAT1Programs
Supported Score]),0)+Nz(Val([DX Programs Supported Score]),0)+Nz(Val([Other
Priority Programs Supported Score]),0)

Many thanks for your help though!

KARL DEWEY said:
I bet that your fields are text datatype and not numeric. It is hard to do
math on 'X' & 'Y'.
Try this --
Raw Score: Nz([Programs Supported Score],0)+Nz([ACAT1Programs Supported
Score],0)+Nz([DX Programs Supported Score],0)+Nz([Other Priority Programs
Supported Score],0)

--
Build a little, test a little.


caro79 said:
I am attempting to sum a row but instead of adding the figures together, the
cell shows the number strung together. For example, if the numbers to sum are
4, 5, 10, and 5 the cell shows 45105 instead of 24. The formula I am using is:

Raw Score: [Programs Supported Score]+[ACAT1Programs Supported Score]+[DX
Programs Supported Score]+[Other Priority Programs Supported Score]

How should I write it so that the answer is an actual sum rather than a
string of numbers?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping - Distinct 5
how do I use array references in VLOOKUP()? 2
How do I select the maximum of a subset of records? 3
Sum and If Function Problem with Excel 2007 5
Does anyone know how to retrieve a maximum value from a row (not . 1
Excel Help: How to have a Competition Leader 2
absolute ranges 3
How do I automatically select a database record randomly? 1

Top