Addition problems

I am having trouble getting columns to add up correctly.  I am using the 
formula @SUM(E6..E67) to add the entries from E6 to E67, but those entries 
(which are dollar amounts, many of which are $6.39) add up to $580.68, when 
the number should be $580.87.

In another column, I am getting a total of $888.64, when I should get 
$888.45 (that column includes a lot of entries of $9.77).

I cannot figure out how to correct this.  I need precise sums, not ones that 
are nearly but not exactly correct.

Thanks. 

I can't report to you yet because I can't quite figure out what you mean.

I have multiple columns of entires.  Column A has the case name, B has the 
Services $ amount, C has the Disbursements $ amount, D has the Total of B 
and C, E has one insurance company's percentage of the total, and so on.

There are no blank columns, and thus, no blank cells to the right of the 
first used value cell.

If I put that code in, with a +1, then the total is confused.  So do I need 
to insert empty columns alongside each full one?

(I am also not sure what you mean by "addresses.")

Sorry!  Any elucidation will be helpful!


"lemoto" <ctech@corel.ca> wrote in message 
news:VA.00004184.019565bd@corel.ca...
>
> H:
>> @SUM(E6..E67) to add the entries from E6 to E67, but those entries
>> (which are dollar amounts, many of which are $6.39) add up to $580.68,

>> when
>> the number should be $580.87.
>>
>> In another column, I am getting a total of $888.64, when I should get
>> $888.45 (that column includes a lot of entries of $9.77).
>>
>> I cannot figure out how to correct this.  I need precise sums
>
> Precise sums are exactly what QP provides.
> Sometimes this is more precise than the user anticipates.
>
> First, in the Cell to the R of the first used Cell in your values Column,
> insert this check formula:
> If your first value Cell is D4, then
> in E4 enter: +D4+1
>
> Most likely you need to alter the addresses to agree with your layout.
>
> Copy that formula down so that every value Cell has a check formula 
> alongside.
>
> You may or may not see that in every case the result shown in the check 
> Cells
> is the expected <existing value> +1.
>
> Please report results.
> -- 
> Good wishes!
> Roy Lewis
> C_Tech volunteer
> (UK)
>
> 

Okay, I figured it out.  Your fix showed me the problem.  The two columns 
that always added "wrong" were the percentage columns.  The problem
was that 
they took the $ amount out only two decimal spaces.  Once I realized what 
the issue had to be (by seeing that the +1 came to a number that extended 
out 6 decimal spaces, it dawned on me.

So all is well now - I just increased the decimal spaces so I can show the 
respective carriers how their numbers added up.

Thank you.


"lemoto" <ctech@corel.ca> wrote in message 
news:VA.00004188.01ed70ad@corel.ca...
>
> H:
>
>> (I am also not sure what you mean by "addresses.")
>
> An address is: A5 or D52
> or more clearly: A:A5 etc
> more clearly yet: [notebookname]C:E21 etc
>
>> B has the
>> Services $ amount, C has the Disbursements $ amount, D has the Total of
B
>> and C, E has one insurance company's percentage of the total, and so
on.
>
> I guess there is a blank column somewhere to the R of that lot.
>
> Dealing to start with with Col B (for no particular reason: it should be 
> one
> of those that are producing apparently erroneous totals) - supposing that 
> the
> first data row is 2, and making the obvious adjustments if not:
>
> In an available blank Column, in the first data row, type
>
> +B2+1
>
> and copy the formula down through the last used data row.
> -- 
> Good wishes!
> Roy Lewis
> C_Tech volunteer
> (UK)
>
> 

H:
> @SUM(E6..E67) to add the entries from E6 to E67, but those entries 
> (which are dollar amounts, many of which are $6.39) add up to $580.68, when

> the number should be $580.87.
> 
> In another column, I am getting a total of $888.64, when I should get 
> $888.45 (that column includes a lot of entries of $9.77).
> 
> I cannot figure out how to correct this.  I need precise sums

Precise sums are exactly what QP provides.
Sometimes this is more precise than the user anticipates.

First, in the Cell to the R of the first used Cell in your values Column,
insert this check formula:
If your first value Cell is D4, then
in E4 enter: +D4+1

Most likely you need to alter the addresses to agree with your layout.

Copy that formula down so that every value Cell has a check formula alongside.

You may or may not see that in every case the result shown in the check Cells 
is the expected <existing value> +1.

Please report results.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

H:
 
> (I am also not sure what you mean by "addresses.")

An address is: A5 or D52
or more clearly: A:A5 etc
more clearly yet: [notebookname]C:E21 etc

> B has the 
> Services $ amount, C has the Disbursements $ amount, D has the Total of B 
> and C, E has one insurance company's percentage of the total, and so on.

I guess there is a blank column somewhere to the R of that lot.

Dealing to start with with Col B (for no particular reason: it should be one 
of those that are producing apparently erroneous totals) - supposing that the 
first data row is 2, and making the obvious adjustments if not:

In an available blank Column, in the first data row, type

+B2+1

and copy the formula down through the last used data row.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)