Some simple excel formula question
[Users questions | Browse:46 | Favorites]
Users questions: Hello, everybody, look at the table, I have an array of little contact, expert answers, thank! Q: = SUM (G4: G10 * H4: H4: H7: H8: H9: H10) What does it mean? How there are so many colon? Please help out, thank you!
Experts answer: = SUM (G4 : G10 * H4: H4: H7: H8: H9: H10) The wording I have not seen, the general pattern is: = SUM (G4: G10 * H4: H10) or G4 * H4 + G5 * H5 + .. .. + G10 * H10 has been tested and provide you with the wording, the middle number Does not matter, it does not matter to repeat the formula identified only two of the largest and the smallest, but the maximum and minimum to the first group match. Therefore, I think that formula is not necessary so that unnecessary feeling, there may be other uses, but I do not understand the intention of writing this.
Experts answer: = SUM (G4 : G10 * H4: H4: H7: H8: H9: H10) The wording I have not seen, the general pattern is: = SUM (G4: G10 * H4: H10) or G4 * H4 + G5 * H5 + .. .. + G10 * H10 has been tested and provide you with the wording, the middle number Does not matter, it does not matter to repeat the formula identified only two of the largest and the smallest, but the maximum and minimum to the first group match. Therefore, I think that formula is not necessary so that unnecessary feeling, there may be other uses, but I do not understand the intention of writing this.
- Cell in Excel for graphics.
- domn down the word document, how to remove shading
- Download the Google input Thunder
- PPT pie method to do? Can quickly learn
- How to restore the default browser status ie
- WORD2003 program is broken
- the difference between word and wps?
- Ask CSS problems
- Hide Add Remove Programs
- Computer system and antivirus software
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.