The query is a bit underspecified...

1]

=SUMIF($A$2:$A$30,H2,$B$2:$B$30)

2]

=SUMPRODUCT(--($A$2:$A$30=H2),$B$2:$B$30+$C$2:$C$30+$D$2:$D$30)

might point you in the right direction.

Fais wrote:
Hi,

I have 350 codes in column H and I want to look down A1:A30 and
see if any non blank values there matche any in Column H then add
the relevant cells in other columns like B, C, D etc

Any help will be greatly appreciated.



Fais.

.