If statement question
How do you write an if statement if there are two factors that need to be true in order for the desired result to happen? I have a basic expenses/credits ledger going whereby I have a field for each expense category separate from my expense/credit portal. In one category field, I want it to total the amount expensed towards this category in the month of January. The way I thought this should go is as follows: Category A amount field: If (Category = A and Date = 1/*/*, expenses, "") Category A summary field: = Total (Category A amount field) The error I'm getting is at the end of the 1st if statement. How should this read? Thank you!