We're sorry but viewer-app doesn't work properly without JavaScript enabled. Please enable it to continue.
Help
Description:
Finds you the right Excel formula for your need.
Example:
ooo excel how to sum all the odd values from B2 to B117 ignoring error cells?
Result:
The formula is =SUMPRODUCT((MOD(ROW(B2:B117),2)=1)*B2:B117)