 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008sumup question
Can any body think of a formula if i want to sum up each collection as follow, because i have a lot of collection cell i have to calculate. A 5000 B 2000 C 3000 Collection : 8000 D 1000 E 2000 F 4000 Collection 7000 G H I Collection What designates the collection?  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Can any body think of a formula if i want to sum up each collection as > follow, because i have a lot of collection cell i have to calculate. [quoted text clipped - 12 lines] > I > Collection The easiest way to do this would be to have categories column, and then use a sumif function to sum the categories > Can any body think of a formula if i want to sum up each collection as > follow, because i have a lot of collection cell i have to calculate. [quoted text clipped - 12 lines] > I > Collection So how excatly i am going to do? "mvk" <mkatkoria@tejniya.com> ???????:618C8138-4D4F-4138-AB23-E433631C73C9@microsoft.com... > The easiest way to do this would be to have categories column, and then > use a sumif function to sum the categories [quoted text clipped - 15 lines] >> I >> Collection First, you need to define the problem so people can understand it. Your first collection of A, B, C adds up to 10,000, but you want 8000 as an answer. Your second collection adds up to 7,000 which is also the answer you want. So tell us, what is the total you want? A plus C and ignore all B's? What other rules are required to be followed in the 'lot of collection's you have? Is it always the previous three numbers? Regards, Fred. > So how excatly i am going to do? > "mvk" <mkatkoria@tejniya.com> [quoted text clipped - 18 lines] >>> I >>> Collection He got his answer in another group. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > First, you need to define the problem so people can understand it. > [quoted text clipped - 31 lines] >>>> I >>>> Collection |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.