Ok, I guess this got sticky because of how detail I'm trying to get it
to be with the multiple criterias. The purpose of this sheet is to
track business expenses amongst about 8 employees.

Assume columns: (with up to a thousand rows of data)
A will consist of Dates
B will consist of Employee Names
C will consist of Transaction Types (i.e. Business lunches, airfare,
etc)
D will consist of the Charge Amounts.

My first obstacle is after meeting the 3 criterias, for a cell to
return the value in column C.
My 2nd obstacle is there are many duplicates. Now there are a lot of
formulas to eliminate them. That's not the case this time.

If row 2 matches all the values in row 1 respectively through columns
A, B, C, and D, then either take the sum of the 2 transactions to show
as one trasnaction type on that day by that employee, or return it in
the next cell and I can just do a sumif function.

Forgive me if i'm not explaining this with complete clarity, but I
guess this is the best I can think to desribe it.

If you have any solutions and/or strategies, please let me know.