Posted to microsoft.public.excel.worksheet.functions

Natalie

external usenet poster

Posts: 44

Sums

Hi,

I have a table of data, and want to create a new sheet adding it up -

Part no Qty
670 1
56 6
98 2
670 3
98 4

And I want to create a new sheet for

Part no total qty
670
56
98

Can anyone help? I have done this before but I can't remember!

Thanks v much

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
SUMS	heather	Excel Worksheet Functions	1	January 26th 09 09:04 PM
Sums	Jemma	Excel Worksheet Functions	6	December 11th 08 06:30 PM
Max sums	RPFD531	Excel Discussion (Misc queries)	1	February 24th 08 03:45 AM
How to add previous sums in a column to current sums in a column?	TD	Excel Worksheet Functions	1	September 30th 06 02:55 PM
Sums	cosmos5955	Excel Discussion (Misc queries)	1	March 30th 06 09:42 PM

All times are GMT +1. The time now is 08:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us