Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Ruediger
You don't mention if you want the additional formula to include the same 'System Details' references. Do these references have predetermined values that add up a score, if so then use the following: =IF($B3=("Y"),'System Details'!$E$7)+IF($C3=("Y"),'System Details'!$E$14)+IF($D3=("Y"),'System Details'!$E$21)+IF($E3=("Y"),'System Details'!$E$28)+IF($F3=("Y"),'System Details'!$E$35)+IF($G3=("Y"),'System Details'!$E$44)+IF($H3=("Y"), 'System Details'!$E$51)+IF($I3=("Y"),'System Details'!$E$58)+IF($J3=("Y"),'System Details'!$E$65)+IF($K3=("Y"),'System Details'!$E$72)+IF($L3=("Y"),'System Details'!$E$79)+IF($M3=("Y"),'System Details'!$E$88)+IF($N3=("Y"),'System Details'!$E$95)+IF($O3=("Y"),'System Details'!$E$100)+IF($P3=("Y"),'System Details'!$E$109)+IF($Q3=("Y"),'System Details'!$E$118)+IF($R3=("Y"),'System Details'!$E$126) NOTE: the change from Semi-Colon (;) to Comma (,) also the ($) - absolute reference to each of your original System Details Cells and the absolute reference for the columns in your main sheet. You can copy/Paste this down as far as you like. HTH Mick. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help simplifying a formula with multiple if's added together... | Excel Worksheet Functions | |||
Multiple IF Statements | Excel Discussion (Misc queries) | |||
Multiple IF statements looking up multiple ranges. | Excel Worksheet Functions | |||
Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
Multiple If/Or Statements | Excel Worksheet Functions |