First one:

=SUMIF(sheet4!A22:A200,A2,sheet4!D2:D200)

if the formula is in a cell on sheet2, otherwise:

=SUMIF(sheet4!A22:A200,sheet2!A2,sheet4!D2:D200)

Second one: I'm not sure what you want.

Hope this helps.

Pete


On Oct 16, 6:22 pm, "Jerry Kinder" wrote:
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