Excel Sumif ??

[Javi]

Hi All,

Can someone please help me change the below formula so that any matches in column $A$1:$A$1000 sums the matches in Column $D$1:$D$1000.

=SUMIF($A$1:$A$1000,"CL2579",$D$1:$D$1000)

 

[VoG]

In what way does that not work?

 

[Jonmo1]

The formula as you have it will do what you ask..

It will sum cells in D1:D1000 where cells in A1:D1000 = "CL2579"

Excel Workbook
	A	D	F
1	Random Text	1	16
2	Random Text	2
3	CL2579	3
4	Random Text	4
5	CL2579	5
6	Random Text	6
7	Random Text	7
8	CL2579	8
9	Random Text	9
10	Random Text	10
Sheet1

 

[Javi]

Sorry I was not clear.

I can not insert the "CL2579" there are to many I need the formula to check all matches in coloumn "A" and sum column "D".

=SUMIF($A$1:$A$1000,"CL2579",$D$1:$D$1000

 

[Javi]

Maybe this is a sumproduct task?

 

[T. Valko]

Maybe this is a sumproduct task?

Can you post some data and tell us what result you expect?

 

[Jonmo1]

Sorry I was not clear.

I can not insert the "CL2579" there are to many I need the formula to check all matches in coloumn "A" and sum column "D".

Sorry, still not clear.

All matches "to what" in column "A" ??

do you have another list of matches somewhere, say B1:B10

In C1, put =SUMIF($A$1:$A$1000,B1,$D$1:$D$1000)
and fill down to C10

 

[Matty]

Try:

=SUMPRODUCT(SUMIF(A$1:A$1000,CriteriaList,D$1:D$1000))

Where CriteriaList is a range of cells containing values such as CL2579.

Matty

 

[Javi]

This may help "Sorry guys"

-----A---------B-----------C
1--123-----$ 2.00------$ 5.50
2--222-----$ 3.50------$ 3.50
3--321-----$ 1.50------$ 6.50
4--421-----$ 2.25------$ 2.25
5--123-----$ 1.00------$ 5.50
6--123-----$ 2.50------$ 5.50
7--555-----$ 5.00------$ 5.00
8--321-----$ 2.00------$ 6.50
9--321-----$ 3.00------$ 6.50

"The formula will be in column C"
Part number in column "A"
Price in column "B"

I need a total price for all of the same parts in column "A".

Line one column C= $5.50 ($2.00 from line1, $1.00 from line5, and $2.50 from line6)

Line two column C= $3.50 (no other matches)

Line three column C = $6.50 (has 3 matches lines 3, 8 and 9)

 

[T. Valko]

This may help "Sorry guys"

-----A---------B-----------C
1--123-----$ 2.00------$ 5.50
2--222-----$ 3.50------$ 3.50
3--321-----$ 1.50------$ 6.50
4--421-----$ 2.25------$ 2.25
5--123-----$ 1.00------$ 5.50
6--123-----$ 2.50------$ 5.50
7--555-----$ 5.00------$ 5.00
8--321-----$ 2.00------$ 6.50
9--321-----$ 3.00------$ 6.50

"The formula will be in column C"
Part number in column "A"
Price in column "B"

I need a total price for all of the same parts in column "A".

Line one column C= $5.50 ($2.00 from line1, $1.00 from line5, and $2.50 from line6)

Line two column C= $3.50 (no other matches)

Line three column C = $6.50 (has 3 matches lines 3, 8 and 9)

Enter this formula in C1 and copy down:

=SUMIF(A$1:A$9,A1,B$1:B$9)