Sumif question - I think?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Column A contains part #s that are listed a varying amount of times
F8Z100
F8Z100
F8Z101
F8Z102
F8Z102
F8Z102
F8Z102

Colum B contains a value associated with the part # in column A
10
15
12
15
11
9
3

In Column C I want a formula that totals the values from Column B if they
have the for the same part # in Column A. (Desired result below)
25
12
-
-
-
38
 
Create a list with distinct values by select column A including the header,
then do data>filter>advanced filter, select copy to another location and
unique records, then use something like

(assume the filtered list starts in H2 with the header in H1)

=SUMIF(A:A,H2,B:B)

then copy down


--


Regards,


Peo Sjoblom
 
Try something like this:

=IF(COUNTIF(A$1:A1,A1)=1,SUMIF(A$1:A$100,A1,B$1:B$100),"")

This will give you the sum against the first occurence of a part
number. I have assumed 100 rows of data - adjust to suit.

Hope this helps.

Pete
 
Here's one option:

=IF(COUNTIF($A$1:A1,A1)=COUNTIF(A:A,A1),SUMIF(A:A,A1,B:B),"-")

Enter into column C and copy down as needed.

HTH,
Elkar
 
Back
Top