Hello all, first time poster here.
I'm looking for some help with a sumif formula that is not working properly and I'm not sure what to do to remedy it.
I'm working on a spreadsheet that is a general ledger for accounting and it has numerous source codes, such as AR, AP, IN, NAR, etc. I need to write a sumif formula that will take each individual code and sum them up individually for a Macro for report reconciliations.
I have another spreadsheet that has categories broken down by expense and revenue and created a sum if formula there. It reads =SUMIF(J2:J999999,"Expense",L2:L999999) and it works fine. I double checked the values by filtering the column as well.
My current sumif reads =SUMIF(J2:J1000000,”AP”,O2:O1000000).
Both columns on each spreadsheet are set to general so it should be reading the text properly. I also checked the values by filtering the source to AP and it should not be 0.
Any thoughts?
Thanks in advance
Bookmarks