Hello I am trying to find out how to get a sum of cells with a specific fixed interval between them
J Jubilado Feb 25, 2010 #1 Hello I am trying to find out how to get a sum of cells with a specific fixed interval between them
B Bernard Liengme Feb 25, 2010 #2 This will sum every seventh value in column A =SUMPRODUCT(--(MOD(ROW(A1:A100),7)=1),A1:A100) best wishes
This will sum every seventh value in column A =SUMPRODUCT(--(MOD(ROW(A1:A100),7)=1),A1:A100) best wishes
T T. Valko Feb 25, 2010 #3 What is the range of cells you want to sum? A1:A100? A22:A559? A777:A22351?
