Total Amount by Month

[Tech56]

Hello,

How can the total "actual" amounts be inserted on the Budget sheet from the 'Transactions' sheet by Category and date to fall in the proper months?

I highlighted yellow the amounts, category, and dates in the Transactions sheet. I put what should be the amounts for the month of January for 'Fuel/Car Wash' and 'Century' categories.

Can this be done with formulas?

Thank you

 

[Faseeh]

Hi,

Please check this:

=SUMPRODUCT(($A10=Transactions!$C$6:$C$17)*(Transactions!$E$6:$N$17)*(Transactions!$A$6:$A$17>=Budget!C$6)*(Transactions!$A$6:$A$17<=EOMONTH(Budget!C$6,0)))

Also see attachment...

 

[Tech56]

Thank you very much for your help. This works great of course adapted to all of the columns.