Sumif question - I think?
 

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

Sumif question - I think?
 

Create a list with distinct values by select column A including the header,
then do datafilteradvanced 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


"irvine79" wrote in message
...
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

Sumif question - I think?
 

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

On Oct 24, 12:01 am, irvine79
wrote:
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

Sumif question - I think?
 

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


"irvine79" wrote:

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