Greetings to everybody,
I have table (aproximately 100x100), and i have to sum every odd or even value in row, also i have to do that in all rows,
I manage to do in single row with
=SUMPRODUCT(MOD( COLUMN($B$5:$LK$5)-1; 2 )*$B$5:$LK$5)
but draging down formula in "sum" column, "5" is not chaning,
is there any other way then manualy changing value "5" into proper row number?
Cheers
Bookmarks