Forum Discussion
Need help on if statement that includes sumif
What version of Excel do you currently have? If you're working with a subscription to Microsoft 365, then you would be well served by learning both the LET function and the LAMBDA function, using them to make these formulas shorter, and, thereby, more readable and maintainable.
Having said that, would it be possible for you to post a copy of the spreadsheet that contains these formulas; it's hard enough trying to decipher a formula that one has written one's self; deciphering one such as you've shown here, with its long and recurring table names (or are they tab names?), is even more difficult. So you could help us help you by posting a copy of the spreadsheet on OneDrive or GoogleDrive, with a link pasted here that grants edit access. That way we could actually test any new formulations with your real database.