Hi,
In work sheet4 and work sheet2 in col A is list of names.
In work sheet2 in Col D are $ amounts and
in cell F4 is a two letter codes. Down colF will be the number 1
occasionally.

I want to if(sheet2 cell A2=sheet4 cell A2:A200,sum(sheet4!D2:D200),"")

Col A of sheet2 is a list of names
In col C2 is a two letter code say, AL.

I want to if(sheet2 cell C2=sheet4 cell F4,sum(sheet4!f5:f200),"")

I hope this makes sense.

Thank you,
JK