Forum Discussion
Formulas and functions
As a general rule, the experts (i.e., the people that write the textbooks on how to use Excel) warn against deeply nested IF formulas. They have a tendency to become unintelligible. A far better alternative would be to break each of your various IF conditional statements as a stand-alone conditional, and then have a single summarizing IF that brings the results of those individual statements together.
In fact, I see you're referring to other sheets within these formulas as well. It might even make sense to take such sub-formulas as SUM('Feb-Mar-22'!D8:D34,'Mar-Apr-22'!D4:D4) and give it its own cell, and then name that cell, so that in subsequent formulas you're referring to FebAprTot or some such mnemonic value. (Do you know about "named ranges" and their utility in writing Excel formulas? If not, here's a useful reference: https://exceljet.net/glossary/named-range)
Breaking things apart like that -- we refer to doing this as using "helper columns" -- can highlight where one or another of the many components might be delivering up that #VALUE error message.
That said, if you could post a copy of the spreadsheet/workbook (after converting any real names to fictitious ones), it would be easier to help.