Sum Product or Sum IF for criteria in multiple columns

[DebbyH]

I am hoping you can provide assistance. I have a worksheet with various account numbers spanning several hundred rows. Although the numbers here are in sequence the accounts could vary 10045, 20048, 81007. What I would like to have happen is to have excel total the sum of a column if the account numbers match.

For instance - YES, I COULD SORT THE ACCOUNT NUMBERS and I COULD REMOVE THE DUPLICATE ACCOUNTS ONCE TOTALED

Account # Service Date Txn Amount Total Txn Amount/Account #
10001 02/09/2018 10.00 10
80012 12/19/2017 25.00 110
80012 07/04/2018 10.00 110
80012 05/02/2017 75.00 110
40013 01/01/2018 15.00 70
40013 02/07/2017 55.00 70
10004 05/01/2017 18.00 18


Any assistance would be appreciated. Thank you.

 

[cerfani]

=SUMIF(A:A,80012,C:C)

that would sum 'Txn Amount Total' for account 80012 (110.00)

you can replace the 80012 with a cell that references the account you want to sum

You could also just create a pivot table with the account numbers listed in the row labels and the amount in the data to sum