| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function
How I can SUM every other Column in the same row?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel function
How I can SUM every other Column in the same row?
Starting from what cell and ending at what cell? A1:J1 ? D15:IV15 ? X101:DD101 ? -- Biff Microsoft Excel MVP "bfrad" wrote in message ... How I can SUM every other Column in the same row? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel function
Is this what you are looking for
To sum the odd columns A,C,E....in the range A1:J1 try =SUMPRODUCT((MOD(COLUMN(A1:J1),2)=1)*A1:J1) and to sum the even columns in the range B,D,F .... =SUMPRODUCT((MOD(COLUMN(A1:J1),2)=0)*A1:J1) If this post helps click Yes --------------- Jacob Skaria "bfrad" wrote: How I can SUM every other Column in the same row? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel function
In my case it's stsrts from J6 the next one is L6, N6 and so on for the next
approx. 100 column approx. to HF6 "T. Valko" wrote: How I can SUM every other Column in the same row? Starting from what cell and ending at what cell? A1:J1 ? D15:IV15 ? X101:DD101 ? -- Biff Microsoft Excel MVP "bfrad" wrote in message ... How I can SUM every other Column in the same row? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel function
Try this:
=SUMPRODUCT(--(MOD(COLUMN(J6:HF6)-COLUMN(J6),2)=0),J6:HF6) -- Biff Microsoft Excel MVP "bfrad" wrote in message ... In my case it's stsrts from J6 the next one is L6, N6 and so on for the next approx. 100 column approx. to HF6 "T. Valko" wrote: How I can SUM every other Column in the same row? Starting from what cell and ending at what cell? A1:J1 ? D15:IV15 ? X101:DD101 ? -- Biff Microsoft Excel MVP "bfrad" wrote in message ... How I can SUM every other Column in the same row? . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel function
Thank you very much. It is working great.
"Jacob Skaria" wrote: Is this what you are looking for To sum the odd columns A,C,E....in the range A1:J1 try =SUMPRODUCT((MOD(COLUMN(A1:J1),2)=1)*A1:J1) and to sum the even columns in the range B,D,F .... =SUMPRODUCT((MOD(COLUMN(A1:J1),2)=0)*A1:J1) If this post helps click Yes --------------- Jacob Skaria "bfrad" wrote: How I can SUM every other Column in the same row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Excel Function from a Cell Through a Function | Excel Worksheet Functions | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
Linear Mode
