K
Ken
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
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