Jan 13 2023 10:02 AM
Please see formula:
Result:
I can't seem to determine the error, the data is a negative $, does that have an impact?
Thank you
Jan 13 2023 10:32 AM
Jan 19 2023 10:11 AM
Thank you for responding, the sum should be a negative result, as the data is from a bank statement. Will the Sumifs formula only give positive results? I have the data formatted as accounting
Jan 19 2023 12:30 PM