[mso] Excell formula

 
            Hi All.

 

            I'm having difficult with an excel formula

 

            A                      B          

 

 

150x19

20

150x19

20

150x19

9

75x25

9

75x25

4

150x19

4

75x25

2

150x19

8

75x25

4

75x50

4

            

 

                  

 

 

 

 

 

 

 

 

 

 

            

            In the 3rd column, 1st row I would like the sum of B column
cells that are corresponding to 150 x 19 in column A

            Then every other C column cell that corresponds to 150x19
will have a 0 in it.

            And so on: So that the first unique figure in column A will
have in column C the sum of Column B with the the equal figure in column
A.

 

            For example the above would finish like this:

 

            A                      B                      C

150x19              20                     41

150x19              20                     0          

150x19              9                      0

75x25               9                      19

75x25               4                      0

150x19              4                      0

75x25               2                      0

150x19              8                      0

75x25               4                      0

75x50               4                      4

 

I would greatly appreciate if somebody could let me know if there is a
formula that is able to do what I need it to do.  

 

 

 

 

Regards

                  

                  Wayne Beasley

                  Internal Sales Supervisor

                  UBEECO Packaging Solutions

                  80 Long St, Smithfield, NSW 2164

                  Phone 9609 8208

                  Mob 0404 463 879

                  www.ubeeco.com.au

 


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: