Forum Discussion
Solved
Help please - Excel formula - SUM IF with AND and link to another sheet
I'm getting an Excel formula error and would appreciate help and guidance! Thanks in advance!! (Screenshot below) In the sheet "Profit and Loss Statement," I'm trying to calculate the following: ...
=SUMIFS('List of Transactions'!C3:C301,'List of Transactions'!F3:F301,"2200 Accounts Receivable",'List of Transactions'!C3:C301,">"&0)
This formula returns the intended result in my sheet.
=SUMIFS('List of Transactions'!C3:C301,'List of Transactions'!F3:F301,"2200 Accounts Receivable",'List of Transactions'!C3:C301,">"&0)
This formula returns the intended result in my sheet.
OliverScheurich - All I can say is, "Wow!" The formula you provided works in my spreadsheet. Thank you SO much!!!