I'm revamping my Expense Report. Essentially, I'm trying to do the following:
Employees enter an expense in table rows (1 per row) and if the expense type is a "Gift" or "Entertainment" then an additional column appears with a pulldown list of client names that are populated from a database lookup.
That's the easy part. What I want to do is have a second table that summarizes (by client name) the total amount of gifts in the first table.
I'm able to get SUMIF to work based on just the expense type but I can't figure out how to add the client name component.
use information from above to populate this table (only if "Gift" or "Entertainment")
Thanks in advance!