Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions |