The following array formula does not calculate correctly:
{=SUM(IF(MOD(COLUMN(B1:J1);3)<>MOD(COLUMN();3);0;B1:J1))}
when it occurs in location A1 in a single row of data
0	1	1	1	1	1	1	1	1	1
	
MS Excel correctly calculates this as 3

3	1	1	1	1	1	1	1	1	1

related to but not the same as problems	19765, 63166, 46681

xml for the sheet is 
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40"
 xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Version>11.9999</Version>
 </DocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <Colors>
   <Color>
    <Index>3</Index>
    <RGB>#C0C0C0</RGB>
   </Color>
   <Color>
    <Index>4</Index>
    <RGB>#FF0000</RGB>
   </Color>
  </Colors>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>9000</WindowHeight>
  <WindowWidth>13860</WindowWidth>
  <WindowTopX>165</WindowTopX>
  <WindowTopY>-15</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s21" ss:Name="Default">
  </Style>
  <Style ss:ID="s27" ss:Name="Normal_">
   <Alignment ss:Vertical="Bottom"/>
   <Font ss:FontName="Helv"/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="86" ss:ExpandedRowCount="1" x:FullColumns="1"
   x:FullRows="1" ss:StyleID="s21">
   <Column ss:StyleID="s21" ss:Width="64.5"/>
   <Column ss:StyleID="s21" ss:Width="29.25"/>
   <Column ss:StyleID="s21" ss:Width="17.25" ss:Span="68"/>
   <Column ss:Index="72" ss:StyleID="s21" ss:Width="66" ss:Span="14"/>
   <Row ss:AutoFitHeight="0" ss:Height="15.1875">
    <Cell ss:StyleID="s27" ss:ArrayRange="RC"
     ss:Formula="=SUM(IF(MOD(COLUMN(RC[1]:RC[9]),3)&lt;&gt;MOD(COLUMN(),3),0,RC
[1]:RC[9]))"><Data
      ss:Type="Number">3</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">1</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Selected/>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
  <x:WorksheetOptions/>
 </Worksheet>
</Workbook>