Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help: SearchAndGet a value Help
Hello
I am rather newbie in excel and need a help with a certain problem I have. On the following url (http://www.fuchka.info/tmp/excel.jpg) You can see a screencapture of excel worksheet and sample data. I need a formula for right table which will scan left table and: 1. compare the "date" (example: columns "H" and "I" should get values only for month June) and then 2. compare the "code" (example: rows in column "G" should return values (from income/outcome cells) corresponding to code number in a row in column E. So .. how do I get "I5" cell ... I check column A for a date in range from June 1st to June 31st, after that I take ALL VALUES from column C for which in column E is code 100. So in my case I have only one value ($100,00). If i would have more then one value, the function should AutoSum them. And now in cell "I5" I get "$100,00". so one more time ... function should check for a specific date range (month) and then for specific code (100 or 101 or 102 or etc) and return SUM of all values in corespoding columns "B" or "C" (depends on income or outcome values). (outcome: if date=june and code=100 return all values from C and autosum them) So can anybody help me with this problem ...? And sorry for my bad english .. :D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: SearchAndGet a value Help | Excel Discussion (Misc queries) |