Add Every Other Row

[Michael]

Hi Folks - I have data that looks like this:

Identity Crimes Seminar - 04/13/2005 16 27 43 13 99
16.16% 27.27% 43.43% 13.13% 100.00%
Internal Affairs Course - 11/08/2004 3 15 6 1 25
12.00% 60.00% 24.00% 4.00% 100.00%


I want to sum 16 and 3 in the first column. Is there a way to sum every
other row in a column? I have 1000 rows of data like this.

Thanks,

Michael

 

[Don Guillett]

=SUMPRODUCT((MOD(ROW(G1:G20),2)=1)*(G1:G20))