is it possible to create a formula that will sum every forth cell in a column? thanks.
J john Oct 10, 2009 #1 is it possible to create a formula that will sum every forth cell in a column? thanks.
C Claus Busch Oct 10, 2009 #2 Hi John, Am Sat, 10 Oct 2009 05:37:01 -0700 schrieb john: is it possible to create a formula that will sum every forth cell in a column? thanks. Click to expand... for values in A1:A100: =SUMPRODUCT((MOD(ROW(1:100),4)=0)*A1:A100) Mit freundlichen Grüssen Claus Busch
Hi John, Am Sat, 10 Oct 2009 05:37:01 -0700 schrieb john: is it possible to create a formula that will sum every forth cell in a column? thanks. Click to expand... for values in A1:A100: =SUMPRODUCT((MOD(ROW(1:100),4)=0)*A1:A100) Mit freundlichen Grüssen Claus Busch
