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