the formula divides all the above by a single dollar amount, I need to and another dollar amount, before we divide. I need to add two dollar amounts together before we divide the second dollar amount would be the column is R4,NonSWLOE. the name value is NonSWLOE. Any help would be appreciated
Unless there's highly confidential information in the spreadsheet itself, could you please post a copy of it in addition to the formula with which you want help. There are a lot of conditions referred to...making it hard to recreate what you're working with.
If there's confidential info, perhaps you could help us help you by posting a mockup without that confidential info, but otherwise representing the reality.