Home |
Search |
Today's Posts |
#1
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 |
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 |