excel formula
 

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

excel formula
 

=IF(ISNUMBER(MATCH(Sheet2!A2,Sheet4!A2:A200,0)),SU M(Sheet4!D2:D200),"")

=IF(Sheet2!C2,Sheet4!F4,SUM(Sheet4!F5:F200),"")


--
---
HTH

Bob

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



"Jerry Kinder" wrote in message
...
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

excel formula
 

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