Posted to microsoft.public.excel.worksheet.functions

Bruce

Posts: n/a

rounding values in in array before sum

Hi,

Anyone know how to round each cell before summing the data.

For example, I have data from A1:A10.
If I sum the data and then round eg.

round(sum(A1:A10),0)

This 'MAY' give me a different answer to rounding each of A1:A10 before the
sum.

How do I do the latter? Is it an array formula?

Rgds,

Bruce

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find the largest product of an array of values?	ryesworld	Excel Worksheet Functions	3	December 2nd 05 06:09 PM
find maximum of two values in an array with same lookup value	Andy M	Excel Discussion (Misc queries)	5	May 13th 05 01:31 PM
Array Manipulation	[email protected]	Excel Worksheet Functions	1	December 22nd 04 10:11 PM
Array Manipulation	[email protected]	Excel Worksheet Functions	0	December 22nd 04 09:33 PM
Formula to list unique values	JaneC	Excel Worksheet Functions	4	December 10th 04 12:25 AM

All times are GMT +1. The time now is 10:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us