Thread: Sumif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default 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