Round numbers THEN add them

[luckyt22]

I am trying to Round a group of numbers and then add up their values...any ideas??? FOR EXAMPLE...i have the following numbers...

100,324.51
53,213.76
34,527.33
344,869.50
18,803.66
241,406.10
2,299.88
38,171.09
183,350.12
71,334.89
66,924.06
472,549.11
166,470.45
215,908.16
34,572.53
52,408.16
251,905.22
59,723.59
20,782.59
131,984.95
334,036.00
3,638.02
30,650.25
314,257.83
46,297.56
3,290,409.32 <= They need to add up to this

Now if you actually did add all those numbesr up it would come out right...except those values actually are a lot longer than just 2 digits after the decimal...so sometimes when i sum those up...i am off .01 or.02 give or take...so what i want to do in the total cell is round all the numbers to 2 decimal places and and those values up...is this possible?

Thanks!
Tom

[aristotle]

Hi,

Assume data is in A2:A26:

=SUM(ROUND(A2:A26,2))

This needs to be confirmed with Ctrl + Shift + Enter because it is an array formula.

Regards,
A

[luckyt22]

your the man

Tom

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com

[Ron Rosenfeld]

On Mon, 1 Aug 2005 07:41:32 -0500, luckyt22
<[email protected]> wrote:

>
>I am trying to Round a group of numbers and then add up their
>values...any ideas??? FOR EXAMPLE...i have the following numbers...
>
>100,324.51
>53,213.76
>34,527.33
>344,869.50
>18,803.66
>241,406.10
>2,299.88
>38,171.09
>183,350.12
>71,334.89
>66,924.06
>472,549.11
>166,470.45
>215,908.16
>34,572.53
>52,408.16
>251,905.22
>59,723.59
>20,782.59
>131,984.95
>334,036.00
>3,638.02
>30,650.25
>314,257.83
>46,297.56
>*3,290,409.32 * <= They need to add up to this
>
>Now if you actually did add all those numbesr up it would come out
>right...except those values actually are a lot longer than just 2
>digits after the decimal...so sometimes when i sum those up...i am off
>01 or.02 give or take...so what i want to do in the total cell is
>round all the numbers to 2 decimal places and and those values up...is
>this possible?
>
>Thanks!
>Tom

When I add up those numbers I get a different answer:

3,136,871.05


But that's probably due to a typo or a missing value in what you posted.

In any event, to ROUND to two decimals and then SUM the result, use the
following *array-entered* formula:

=SUM(ROUND(A1:A24,2))

To *array-enter* a formula, after typing or pasting the formula into the
formula bar, hold down <ctrl><shift> while hitting <enter>. Excel will place
braces {...} around the formula if you did it correctly.


--ron

[Andrew L via OfficeKB.com]

Aaah, the old 'customer doesn't think you can add problem'. I've had the
same with pricing issues myself.

Try :

=SUM(ROUND(A1:A13,2)

Then hold down the CTRL + SHIFT keys as you press the ENTER key. This will
create an "array formula". The result will look like {=SUM(ROUND(A1:A13,2)}
in your formula bar.

Regards,
Andrew


--
Message posted via http://www.officekb.com