Expense Sum Formula
I need to be able to calculate expenses per event and per expense type. I feel silly asking as I should know this but my brain just isn't calculating today.
I have tried many variations of the following and it's still Unparsable. I've also tried adding @cell. What am I missing?
=SUMIF([Event Title]:[Event Title], "MS CI Institute", AND ([Expense Type]:[Expense Type], "AV", "Facility Rental", [Payment Amount]:[Payment Amount]))
Help Article Resources
Check out the Formula Handbook template!