Invoice Reconciliation

[Erin3860]

I have two lists that I need to reconcile, one is the list of invoices that were sent in for processing (manually entered data) and the other is the financial system's record once the invoices are processed. We want to make sure everything gets processed and that everything matches. I want to cross reference four different columns as there is no one unique identifier (i.e. each invoice is coded to multiple account codes, etc.). I am having success with this formula:

=SUMIFS(Table1[Row],Table1[Vendor],F2,Table1[Invoice Number],H2,Table1[Account],L2,Table1[GL Amount],U2)

But I would like to make the Row Numbers non-numerical (i.e. instead of 1,2,3, and I want it to be A1, A2, etc. Which throws off the SUM part of this equation.

Any ideas?

 

[Rijnsent]

Hi Erin,
welcome to the forum. SUMIFS indeed can't add up texts (I can't either tbh), so you could try a COUNTIFS formula. What you could also do is make a "helper column" based on your 4 columns, basically creating an unique identifier for every line and try to match those. That does require 2 extra columns but that makes the formula quite a bit shorter and easier to work with.
Hope that helps,
Koen