Sumif formula with current month as criteria

Hi,

Need help fixing my formula I am trying to calculate all my monthly expenses from different sheets in my workbook the formula i have for just my normal transactions but I would like to sum my CC if applies to that month and category of my budget.

=SUMIF(Transactions!$E$6:$E$254,'Monthly Expense'!B15,Transactions!$D$6:$D$254)+SUMIF(JoeExpenseScheels[Category],'Monthly Expense'!B15,JoeExpenseScheels[Amount])

I have a date column "C" in that sheet, I also just have the month and year in the Monthly Expense sheet B3 and B4

Can you attached a "dummy" of the workbook, as the description is rather confusing?

For activity in a date range, the formula is
=sumifs(Values,Date range,">="&(Date),Date range,"<="&(EOMONTH(date),Categories,chosen Category)
(i.e. Sum all values for whatever category, where the transaction date is between the selected date and the end of that month).

Ochimus

Something like

=SUMIFS(Transactions!$D$6:$D$254,Transactions!$E$6:$E$254,'Monthly Expense'!B15,Transactions!$C$6:$C$254,">="&DATE('Monthly Expense'!B4,'Monthly Expense'!B3,1),Transactions!$C$6:$C$254,"<="&EOMONTH(DATE('Monthly Expense'!B4,'Monthly Expense'!B3,1),0))

That's just the first half of your formula, same method applies to the second part.

Here is a sample of my workbook, I need the sumif formula on sheet "Monthly Expense" under actual column

It looks like Ochimus misinterpreted your sample data, the relevant data in the transactions sheet also has the same layout as the card sheets, so no need to add that one separately, if you're going to use the 3d method then might as well do it all that way.

While I was tracing the formulas and named ranges to see if there was a 'proper' date anywhere that could be used, I found that your named range, 'Year' refers back to =YEAR(TODAY()) which I have replaced with the actual year, 2018. Using TODAY() will give you bad results if, for example you try to view December 2018 data in January 2019.

In the attached file, I've amended the named range, 'SHEETS' that Ochimus added, to include the Transactions sheet, also added 2 new defined names, Month_Start and Month_End to give the start and end of the month specified in the cash flow sheet.

Finally, I've updated the formulas in D6:D20 to include the changes above.

=SUMPRODUCT(SUMIFS(INDIRECT("'"&SHEETS&"'!"&"D6:D200"),INDIRECT("'"&SHEETS&"'!"&"E6:E200"),B6,INDIRECT("'"&SHEETS&"'!"&"C6:C200"),">="&Month_Start,INDIRECT("'"&SHEETS&"'!"&"C6:C200"),"<="&Month_End))