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

Please Login or Register  to view this content.

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.

---