Erin M 2021
Member
- Local time
- Today, 10:34
- Joined
- Apr 14, 2021
- Messages
- 77
Columns: AppealID, ExpenseCode, ExpenseAmt
There can be several Expense codes per AppealID but the AppealID table will change over time. How can I generically say SUMIF ("AppealID is the same",ExpenseAmt)
What I don't want to do is have to recode this each year when new AppealIIDs are added.
=SUMIF([AppealID],"Specific Appeal ID",[ExpenseAmt])
Thanks in advance.
There can be several Expense codes per AppealID but the AppealID table will change over time. How can I generically say SUMIF ("AppealID is the same",ExpenseAmt)
What I don't want to do is have to recode this each year when new AppealIIDs are added.
=SUMIF([AppealID],"Specific Appeal ID",[ExpenseAmt])
Thanks in advance.