D Dave May 29, 2006 #1 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
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
A Ardus Petus May 29, 2006 #2 =SUM(IF(MOD(COLUMN(H1:IV1),2)=0,H1:IV1)) Array formula, to be validated wit Ctrl+Shift+Enter, not just Enter HTH
=SUM(IF(MOD(COLUMN(H1:IV1),2)=0,H1:IV1)) Array formula, to be validated wit Ctrl+Shift+Enter, not just Enter HTH
B Biff May 29, 2006 #3 Hi! Try this: Sums every other cell starting from H1 to IV1. =SUMPRODUCT(--(MOD(COLUMN(H1:IV1)-COLUMN(H1),2)=0),H1:IV1) Biff
Hi! Try this: Sums every other cell starting from H1 to IV1. =SUMPRODUCT(--(MOD(COLUMN(H1:IV1)-COLUMN(H1),2)=0),H1:IV1) Biff
D Dave May 29, 2006 #4 Ardus Thanks, that works great! Dave Ardus Petus said: =SUM(IF(MOD(COLUMN(H1:IV1),2)=0,H1:IV1)) Array formula, to be validated wit Ctrl+Shift+Enter, not just Enter HTH Click to expand...
Ardus Thanks, that works great! Dave Ardus Petus said: =SUM(IF(MOD(COLUMN(H1:IV1),2)=0,H1:IV1)) Array formula, to be validated wit Ctrl+Shift+Enter, not just Enter HTH Click to expand...