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)