I have data in 3 different columns and want to use criteria from column A and
B and to give me the result of column C in a different worksheet.

e.g
A B C
Finance Debbie 10
IT Bill 20
Finance Debbie 15
Finance Angie 30

I want to gather the total amount (C) of all Finance (A) Debbie (B) to a
different worksheet.

What formula do I use?