Rolling month

Does anyone know how to make this formula; I have been working on different types all day.
I keep all my transactions, from my bank account in an excel document. Columns listed (date, description, category, debit, credit, balance, and recorded). And the rows are simply the transactions.
What I want it to do is add all of the debits from one category ex. “food” , but only those from the last month. Can anyone help me with this?
thanks

Assuming all dates are in the past this will sum debits for "food" in the last 30 days

=SUMPRODUCT((A2:A100>TODAY()-30)*(C2:C100="food"),D2:D100)

Originally Posted by daddylonglegs

Assuming all dates are in the past this will sum debits for "food" in the last 30 days

=SUMPRODUCT((A2:A100>TODAY()-30)*(C2:C100="food"),D2:D100)

Thanks allot, it works ! I guess I was just making it to complicated