How do I get a sum of every seventh cell in a column?
in [Functions]
|
Prev: Can multiple criteria be used for IF formulas?
Next: Retrieve unique items with 2 criteria (USING SUMPRODUCT)
From: Jubilado on 25 Feb 2010 10:49 Hello I am trying to find out how to get a sum of cells with a specific fixed interval between them
From: Bernard Liengme on 25 Feb 2010 11:26 This will sum every seventh value in column A =SUMPRODUCT(--(MOD(ROW(A1:A100),7)=1),A1:A100) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Jubilado" <Jubilado(a)discussions.microsoft.com> wrote in message news:44571D0E-0C6F-47BD-97D4-0C98EA596E6A(a)microsoft.com... > Hello I am trying to find out how to get a sum of cells with a specific > fixed > interval between them
From: T. Valko on 25 Feb 2010 12:49
What is the range of cells you want to sum? A1:A100? A22:A559? A777:A22351? -- Biff Microsoft Excel MVP "Jubilado" <Jubilado(a)discussions.microsoft.com> wrote in message news:44571D0E-0C6F-47BD-97D4-0C98EA596E6A(a)microsoft.com... > Hello I am trying to find out how to get a sum of cells with a specific > fixed > interval between them |