excle formula problem
[Users questions | Browse:78 | Favorites]
Users questions: = A01: A10 + B01 Why does this formula is the result of A01 + B01, automatic re-count I on the hook, what solution?
Experts answer:1, A01 should be replaced by A1, B01 to B1. 2, when the formula "= A1: A10 + B1" in the first row, the Return value is A1 + B1; when the formula in the second row, the return value, compared with A2 + B1; When the formula in the third row, its return value, compared with A3 + B1 ...... 3, more desirable The summation formula should be "= SUM (A1: A10, B1)". Of course, but "= A1 + A 2 + A3 + A4 + A5 + A6 + A7 + A8 + A9 + A10 + B1 ", but is too cumbersome. For reference.
Experts answer:1, A01 should be replaced by A1, B01 to B1. 2, when the formula "= A1: A10 + B1" in the first row, the Return value is A1 + B1; when the formula in the second row, the return value, compared with A2 + B1; When the formula in the third row, its return value, compared with A3 + B1 ...... 3, more desirable The summation formula should be "= SUM (A1: A10, B1)". Of course, but "= A1 + A 2 + A3 + A4 + A5 + A6 + A7 + A8 + A9 + A10 + B1 ", but is too cumbersome. For reference.
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.