Assistance

[WKT_BWR]

Hi, I took over another persons excel sheet.  We added another factor in the formula and need to modify this formula: 

=IF(AB4<>"N", IF(I4="Y",150, (
(HLOOKUP(J4,BI_FACTORS,2,FALSE)*BIF1_Weight) +
(HLOOKUP(K4,BI_FACTORS,3,FALSE)*BIF2_Weight) +
(HLOOKUP(L4,BI_FACTORS,4,FALSE)*BIF3_Weight) +
(HLOOKUP(M4,BI_FACTORS,5,FALSE)*BIF4_Weight) +
(HLOOKUP(N4,BI_FACTORS,6,FALSE)*BIF5_Weight) +
(HLOOKUP(P4,UrgencyWeights,2,FALSE)) +
(HLOOKUP(S4,TechnicalRiskWeights,2,FALSE))) /
(HLOOKUP(Q4,LevelOfEffortWeights,2,FALSE))),0)

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

[#2]

@WKT_BWR 

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.