| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
