| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on conditional
Here is what I have,
=SUM(IF(Sheet1!D9="JF",Sheet1!E9,0)+IF(Sheet1!D10= "JF",Sheet1!E10,0)+IF(Sheet1!D11="JF",Sheet1!E11,0 )+IF(Sheet1!D12="JF",Sheet1!E12,0)+IF(Sheet1!D13=" JF",Sheet1!E13,0)+IF(Sheet1!D14="JF",Sheet1!E14,0) +IF(Sheet1!D15="JF",Sheet1!E15,0)+IF(Sheet1!D16="J F",Sheet1!E16,0)*IF(Sheet1!D17="JF",Sheet1!E17,0)+ IF(Sheet1!D18="JF",Sheet1!E18,0)+IF(Sheet1!D19="JF ",Sheet1!E19,0)+IF(Sheet1!D20="JF",Sheet1!E20,0)+I F(Sheet1!D21="JF",Sheet1!E21,0)+IF(Sheet1!D22="JF" ,Sheet1!E22,0)+IF(Sheet1!D23="JF",Sheet1!E23,0)+IF (Sheet1!D24="JF",Sheet1!E24,0)+IF(Sheet1!D25="JF", Sheet1!E25,0)) is there a simpler formula to use so I dont have to add a condition every time I add a row in sheet1? Thanks, Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula - language needed | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Threaded Mode
