SUMIF? Or other?
 

Excel2003 ...

Range A4:A50 ... contains Text (may repeat)
Range D4:J50 .... contains numbers
Range A52:A57 ... contains "unique" Text from Range A4:A50

I want to sum all the values in Range D4:J50 when the value in Range A4:A50
matches "unique" value in Range A52:A57.

My 1st formula is ... =Sumif(A4:A50,A52,D4:J50) ... but it is not returning
value I expect.

Col A ..... Col D thru Col J

aaaa 1 - 3 - 0 - 3 - 0 - 0 - 0
bbbb 0 - 0 - 0 - 1 - 0 - 0 - 4
aaaa 2 - 1 - 2 - 0 - 1 - 1 - 1
cccc 4 - 2 - 0 - 0 - 2 - 1 - 0
aaaa 3 - 0 - 1 - 1 - 1 - 1 - 2
bbbb 1 - 2 - 1 - 2 - 0 - 2 - 1

Unique ... (return value I wish)

aaaa ... = 24
bbbb ... = 14
cccc ... = 9
etc

Thanks ... Kha

SUMIF? Or other?
 

=SUMPRODUCT((A4:A50=A52)*(D4:J50))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ken" wrote in message
...
Excel2003 ...

Range A4:A50 ... contains Text (may repeat)
Range D4:J50 .... contains numbers
Range A52:A57 ... contains "unique" Text from Range A4:A50

I want to sum all the values in Range D4:J50 when the value in Range
A4:A50
matches "unique" value in Range A52:A57.

My 1st formula is ... =Sumif(A4:A50,A52,D4:J50) ... but it is not
returning
value I expect.

Col A ..... Col D thru Col J

aaaa 1 - 3 - 0 - 3 - 0 - 0 - 0
bbbb 0 - 0 - 0 - 1 - 0 - 0 - 4
aaaa 2 - 1 - 2 - 0 - 1 - 1 - 1
cccc 4 - 2 - 0 - 0 - 2 - 1 - 0
aaaa 3 - 0 - 1 - 1 - 1 - 1 - 2
bbbb 1 - 2 - 1 - 2 - 0 - 2 - 1

Unique ... (return value I wish)

aaaa ... = 24
bbbb ... = 14
cccc ... = 9
etc

Thanks ... Kha

SUMIF? Or other?
 

Yes ... worked perfect ... (Once I got rid of a hidden character in 1 of my
cells)

Thanks for supporting these boards ... Kha

"Bob Phillips" wrote:

=SUMPRODUCT((A4:A50=A52)*(D4:J50))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ken" wrote in message
...
Excel2003 ...

Range A4:A50 ... contains Text (may repeat)
Range D4:J50 .... contains numbers
Range A52:A57 ... contains "unique" Text from Range A4:A50

I want to sum all the values in Range D4:J50 when the value in Range
A4:A50
matches "unique" value in Range A52:A57.

My 1st formula is ... =Sumif(A4:A50,A52,D4:J50) ... but it is not
returning
value I expect.

Col A ..... Col D thru Col J

aaaa 1 - 3 - 0 - 3 - 0 - 0 - 0
bbbb 0 - 0 - 0 - 1 - 0 - 0 - 4
aaaa 2 - 1 - 2 - 0 - 1 - 1 - 1
cccc 4 - 2 - 0 - 0 - 2 - 1 - 0
aaaa 3 - 0 - 1 - 1 - 1 - 1 - 2
bbbb 1 - 2 - 1 - 2 - 0 - 2 - 1

Unique ... (return value I wish)

aaaa ... = 24
bbbb ... = 14
cccc ... = 9
etc

Thanks ... Kha