excel formula

[Pete_UK]

First one:

=SUMIF(sheet4!A22:A200,A2,sheet4!D2200)

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

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

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

Hope this helps.

Pete

 

[Bob Phillips]

=IF(ISNUMBER(MATCH(Sheet2!A2,Sheet4!A2:A200,0)),SUM(Sheet4!D2200),"")

=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]

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!D2200),"")

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