Posted to microsoft.public.excel.misc

KLock

external usenet poster

Posts: 16

sum grouping

If I have the following entries
Reason Time
Reason1 50
Reason3 45
Reason3 40
Reason2 35
Reason1 65

What function will give me the output?
Reason total time
Reason1 115
Reason2 35
Reason3 80

A pivot table would not work for me as I am trying to sum tables from
different tabs. Thank you for any help.

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
grouping	Pammy	Excel Discussion (Misc queries)	1	March 29th 07 06:22 AM
Grouping	Kay	Excel Discussion (Misc queries)	1	January 21st 06 01:24 PM
Grouping	Vitruvius	Excel Worksheet Functions	1	August 16th 05 09:07 PM
Grouping	Ray	Excel Discussion (Misc queries)	0	March 2nd 05 04:51 PM
Grouping	Lila	Excel Discussion (Misc queries)	1	March 1st 05 03:33 AM

All times are GMT +1. The time now is 02:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us