S
suek
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"?
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"?