I have a file with so many 'Material' in column 'B'.These material have in 2 category,i.e.1-SPTR ( All materials not end with 'S') and ZSPR (All Materials end with 'S' only).
Now,I want to sum up ( Col.F ) the 'Material' ( Col.B ) according to 'Material Group' ( Col.D) in column 'I' and 'J' ( Both group separately ).How can we sum up the total of these categories? Please suggest an excel formula and VBA codes,which is the best, to find the result .
For more clarification,please refer my attach file.
How to sum up the 2 different group's Materials
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
How to sum up the 2 different group's Materials
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: How to sum up the 2 different group's Materials
Do you have many sheets that need to be summed by the material group, or is it just one or two sheets?
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: How to sum up the 2 different group's Materials
I have only one sheet.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: How to sum up the 2 different group's Materials
OK. Then all you need is some formulas to calculate those values.
I will send you you sample workbook back with the necessary formulas soon.
I will send you you sample workbook back with the necessary formulas soon.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: How to sum up the 2 different group's Materials
Workbook attached...
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: How to sum up the 2 different group's Materials
Please note:
The formulas are based on arrays.
If you edit or copy the formulas you must press CTRL+SHIFT+ENTER to confirm them, else they will not calculate properly.
You cannot type the curly brackets in manually { }. These are added when you press CTRL+SHIFT+ENTER.
The formulas are based on arrays.
If you edit or copy the formulas you must press CTRL+SHIFT+ENTER to confirm them, else they will not calculate properly.
You cannot type the curly brackets in manually { }. These are added when you press CTRL+SHIFT+ENTER.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: How to sum up the 2 different group's Materials
Glad to find the problem sort out formula.Thanks a lot Rudi for your nice cooperation.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: How to sum up the 2 different group's Materials
Cross-posted (and answered) at: http://www.msofficeforums.com/excel-pro ... p-2-a.html" onclick="window.open(this.href);return false;
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184" onclick="window.open(this.href);return false;
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184" onclick="window.open(this.href);return false;
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]