Dates: Data Validation, Sumif
 

Hello!

I am trying to do a budget of expenses:

First of all, I have a Due Date column list made through data validation
which has Mar-10; Apr-10; May-10; etc all the way through to Jun-11.

I have then formatted the cells where I have data validation to custom :
mmm-yyyy so I didn't get the number
So I have a spreadsheet with the columns: Item, Amount,(Column H) Due
Date(Column I)
and this formula to get my all liabilities for Mar-10 in a separate column:

=SUMIF(H3:I71, "Mar-10",H3:H71)

This formula is not working, it has something to do with the date as it
returns 0 even though I have expenses in column h for march.

Is this something to do with how the date is being "read"?

Dates: Data Validation, Sumif
 

Try
=SUMPRODUCT((TEXT(I3:I71,"mmyyyy")="032010")*(H3:H 71))

--
Jacob


"suek" wrote:

Hello!

I am trying to do a budget of expenses:

First of all, I have a Due Date column list made through data validation
which has Mar-10; Apr-10; May-10; etc all the way through to Jun-11.

I have then formatted the cells where I have data validation to custom :
mmm-yyyy so I didn't get the number
So I have a spreadsheet with the columns: Item, Amount,(Column H) Due
Date(Column I)
and this formula to get my all liabilities for Mar-10 in a separate column:

=SUMIF(H3:I71, "Mar-10",H3:H71)

This formula is not working, it has something to do with the date as it
returns 0 even though I have expenses in column h for march.

Is this something to do with how the date is being "read"?