Erin Peters
New Member
- Joined
- Dec 29, 2016
- Messages
- 5
I am using an Index Match formula to match multiple columns by Account #. Then I need to add the payments for those account numbers together from the payment column if they match the account number in the first column. Here is my formula below.
Account #s are in Column A on Sheet 1! and Column A on Sheet 2!. Payments are in Column C on Sheet 2.
=INDEX(Sheet2!$C2:$C1473,MATCH('Sheet 1'!$A2:$A532,Sheet 2'!$A2:$A1473,0))
My issue is it is only giving the first match it finds, not summing them. I have used SUMIF AND SUMIFS, but am not using them correctly.
Thank you
Account #s are in Column A on Sheet 1! and Column A on Sheet 2!. Payments are in Column C on Sheet 2.
=INDEX(Sheet2!$C2:$C1473,MATCH('Sheet 1'!$A2:$A532,Sheet 2'!$A2:$A1473,0))
My issue is it is only giving the first match it finds, not summing them. I have used SUMIF AND SUMIFS, but am not using them correctly.
Thank you