| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
generate automatically sum
Please help on this:
I have 5 colomn with 6 row with number 1 or 0 A B C D E 0 1 0 1 1 1 0 0 1 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 1 1 1 0 1 It's possibile to generate in column F all possibile results if sum one cell in every row. If i make simple formula (add one cell in everry row, one by one) will look like that: F A1+A2+A3+A4+A5+A6 A1+A2+A3+A4+A5+B6 .... A1+A2+A3+B4+B5+B6 .... B1+A2+A3+A4+B5+B6 .... B1+C2+A3+D4+B5+E6 .... E1+E2+E3+E4+E5+E6 It was 15625 (5^) formulas to insert . Can i GENERATE ALL THIS SUMS automatically? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically generate letter | Excel Discussion (Misc queries) | |||
| How do I automatically generate an invoice number | Excel Worksheet Functions | |||
| automatically generate links from a directory and its sub-directories | Links and Linking in Excel | |||
| how can I use excel to automatically generate routine report? | Excel Worksheet Functions | |||
| How do I automatically generate dates? | Excel Discussion (Misc queries) | |||
Threaded Mode
