How to get date intervall in Index and Match?

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.

---