Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif
Is there a way to add alternate columns in a row of numbers? I need to add
the value in Column H, J, L, N etc to IV. Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif
=SUM(IF(MOD(COLUMN(H1:IV1),2)=0,H1:IV1))
Array formula, to be validated wit Ctrl+Shift+Enter, not just Enter HTH -- AP "Dave" a écrit dans le message de news: ... Is there a way to add alternate columns in a row of numbers? I need to add the value in Column H, J, L, N etc to IV. Dave |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif
Hi!
Try this: Sums every other cell starting from H1 to IV1. =SUMPRODUCT(--(MOD(COLUMN(H1:IV1)-COLUMN(H1),2)=0),H1:IV1) Biff "Dave" wrote in message ... Is there a way to add alternate columns in a row of numbers? I need to add the value in Column H, J, L, N etc to IV. Dave |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif
Ardus
Thanks, that works great! Dave "Ardus Petus" wrote in message ... =SUM(IF(MOD(COLUMN(H1:IV1),2)=0,H1:IV1)) Array formula, to be validated wit Ctrl+Shift+Enter, not just Enter HTH -- AP "Dave" a écrit dans le message de news: ... Is there a way to add alternate columns in a row of numbers? I need to add the value in Column H, J, L, N etc to IV. Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |