Sum one column based on two criteria

[coopman64]

I'm trying to modify a budget worksheet that currently shows the monthly totals spent for each category to show the totals for the first half and second half of the month. I have a tab named transactions that contains data which is essentially a check register. The date of transaction is in column B, the categories are in column F and the amounts are in column J. The front page is the overview for the month, and cell E4 is the first day of the month. My formula works individually, but when I combine them, it doesn't work. Here's my formula:

=SUMIFS(Transactions!J:J,Transactions!B:B,""<="(EOMONTH(E4,-1)+INT(DAY(EOMONTH(E4,0))/2)",Transactions!F:F,"<-="&A33)

[benishiryo]

hi coopman64. if you want a date range (1st Feb to 14th Feb for eg), you need 2 criteria range & criteria for it.
1. >= 1 feb
2. <= 14 feb

unless your data only compromises of Feb data. then you can just use "<=" 14feb. in here, you seem to have an extra double quotes & without the ampersand after "<=".
""<="(EOMONTH(E4,-1)+INT(DAY(EOMONTH(E4,0))/2)"

maybe something like this:
=SUMIFS(Transactions!J:J,Transactions!B:B,">="&E4,Transactions!B:B,"<="&E4+INT(DAY(EOMONTH(E4,0))/2)-1,Transactions!F:F,A33)

but i dont understand the last category portion too. if you still can't get it, upload a sample Excel file. that always helps

[coopman64]

Thank you, that was the problem.