Formula for Sum every third column

[omnivl]

Using the below

Type	1			2			3			4			5			6
Type	1			2			3			4			5			6
Type	1			2			3			4			5			6

<tbody>
</tbody>

So if i autofilled =sum(B:B) right it would return

Type	3	0	0	6	0	0	9	0	0	12	0	0	15	0	0	18

<tbody>
</tbody>

how could i get it to display

Type	3	6	9	12	15	18

<tbody>
</tbody>

 

[AlphaFrog]

Try this...

=SUM(INDEX($B:$Q,0,COLUMN(A1)*3-2))

 

[omnivl]

Awesome thanks!, and...i understand it now

Try this...

=SUM(INDEX($B:$Q,0,COLUMN(A1)*3-2))