| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum of every other two columns
You can try using Sum Product to do this.
A quick and dirty way would be to add a row to the top of your sheet. In row 1, put 1, 0, 1, 0, 1, 0..... in each of the columns The in your sumproduct formula, you would say: =sumproduct(A2:DU2,$a$1:$DU$1) This formula will add each column that has a 1 in row 1. On Oct 3, 4:44*pm, sem_lady wrote: Hi *I have data in columns A through DU. I'm looking for a formula that will add every other two columns example. sum(A1,B1,E1,F1,I1,J1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
