Help: SearchAndGet a value Help

[fuchka]

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 ..

 

[Guest]

See responses to your multi-post in .worksheet.functions
(Please do not multi-post ... uurgh!)