excel

excel

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)

Veja também

Category:
Help
Category:
Help
Category:
Help
Category:
Help