| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding formulas
Hello
I wonder how I can make this formula shorter/easyer? Can anyone help me? =HVIS(F6=C83;B6;0)+HVIS(F7=C83;B7;0)+HVIS(F8=C83;B 8;0)+HVIS(F9=C83;B9;0)+HVIS(F10=C83;B10;0)+HVIS(F1 1=C83;B11;0)+HVIS(F12=C83;B12;0)+HVIS(F13=C83;B13; 0)+HVIS(F14=C83;B14;0)+HVIS(F15=C83;B15;0)+HVIS(F1 6=C83;B16;0)+HVIS(F17=C83;B17;0)+HVIS(F18=C83;B18; 0)+HVIS(F19=C83;B19;0)+HVIS(F20=C83;B20;0)+HVIS(F2 1=C83;B21;0)+HVIS(F22=C83;B22;0)+HVIS(F23=C83;B23; 0)+HVIS(F24=C83;B24;0)+HVIS(F25=C83;B25;0)+HVIS(F2 6=C83;B26;0)+HVIS(F27=C83;B27;0) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding formulas across Worksheets | Excel Worksheet Functions | |||
| Adding formulas | Excel Worksheet Functions | |||
| Adding formulas after rows | Excel Discussion (Misc queries) | |||
| Adding rows in between formulas | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
