How to get date intervall in Index and Match?

Originally Posted by Stoffe

Hi
I hope somebody can help me, excuse my english language...
I have 4 column that show:

First column: Date
Second column: Information
Third column: Debit
Forth column: Credit

In Date i have several date start from 1/1/07 to 3/5/07

I want to pick a value from Credit for january as 1/1/07 - 1/31/07 due to Information wich i pay rent for my home.
Something i think to use is Index and Match, but how to get it looking for just januari?
Date interval as

 (Date>=1/1/07)*(Date<=1/31/07)

Is it possible to make it in Index and match?

Hope i explain well here..

HI,

If I have read your question correctly, you want to total the Credit column for just a specific month, in this case January.

try

=SUMPRODUCT(--(A1:A100>=DATE(2007,1,1)),--(A1:A100<=DATE(2007,1,31)),D1:D100)

where the A1:A100 & D1:D100 will need to reflect your data rows.

Also I recommend putting the date(s) in a cell and then you are able to select different periods without changing the formula.

hth
---

Originally Posted by Stoffe

Hi Bryan!
Thank for response..

This is only one value like a cell in D1:D100, not total sum for january.

Date____Information_____Debit___Credit
2/2/07__Bankomat_______________300
.
.
1/30/07_Home-bill_______________4000
.

I want a formula that looking for Home-bill in January that find the value 4000.
I did not pay home-bill last date in every month, but at least once...
A formula looking for Home-bill in January to pick upp 4000 in column D.

I've looking for that in several homepage, did not find like date interval by lookup or index-match...
Hope somebody know how to do...
And tell me..

Hi,

checking back to your original post, I did not see that requested, however, try

=SUMPRODUCT(--(A1:A100>=DATE(2007,1,1)),--(A1:A100<=DATE(2007,1,31)),--(B1:B100="Home_Bill"),D1:D100)

hth
---

Originally Posted by Stoffe

Great!!

Thank you! Bryan! It work!

good to see, and thanks for the response.

---