summing every second row and show result in adjacent colum withouth - Microsoft Community

hi,

i sum values of every second row (soil n content per layer) , show result in a new sheet in way results under each other, without empty cells between them; using formula: 

=if(mod(row(),2)=1,h43+h44,"")

but in results column (soil n content per field), every second cell empty because contains data (although data not shown looks blank cell), looks (say, sheet "a"):

field (sheet a)	layer (cm bss) (sheet a)	soil n content per layer (sheet a)	soil n content per field
1	0-15	1160	2160
1	15-30	1000
2	0-15	1070	2030
2	15-30	960
3	0-15	1050	2020
3	15-30	970
4	0-15	1010	2020
4	15-30	1010
5	0-15	1130	2220
5	15-30	1090

but have (the field column in other sheet, sheet "b", have results of sum of every second row of soil n content per layer from sheet "a"):

field (sheet b)	soil n content per field (sheet b)
1	2160
2	2030
3	2020
4	2020
5	2220

as the soil n content per field is in sheet where have column field

hope helps

best wishes

Office / Excel / Other/unknown / Unknown/other