[mso] Re: Excell formula
- From: Thomas Hutchins <hutch99999@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 24 Apr 2008 06:40:05 -0700 (PDT)
Assuming your data begins in A1, paste this formula in C1 and copy down:
=IF(COUNTIF($A$1:A1,A1)=1,SUMIF($A$1:$A$19,A1,$B$1:$B$19),0)
Adjust the SUMIF ranges as necessary. I based this example on your sample
data.
Hope this helps,
Hutch
--- On Thu, 4/24/08, Wayne Beasley <wayne.beasley@xxxxxxxxxxxxx> wrote:
From: Wayne Beasley <wayne.beasley@xxxxxxxxxxxxx>
Subject: [mso] Excell formula
To: mso@xxxxxxxxxxxxx
Date: Thursday, April 24, 2008, 1:05 AM
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
3rdcolumn, 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:
AB 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
0404463 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
itto 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). //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
problemfiles, 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
*************************************************************
----------------------------------------------------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
now.[1]
--- Links ---
1
http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
*************************************************************
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).
//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:
