Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
andreea_bianca24
 | Femeie
24 ani
Mures
cauta Barbat
24 - 58 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
To automatically add ; or , separators between items inside formulas, eg. =SUMIF(criteria_range;criteria;sum_range), without having to manually tap the specific button, when selecting the items (eg. range, cell) you should have CTRL pressed.
As in, write =SUM( then press CTRL and select criteria_range then criteria cell then sum_range, the separator will be added automatically by Excel.
The only disadvantage of this method is that for absolute ranges you would have to first enter the whole formula, then select the desired ranges inside it manually and hit F4 for each of them
See this video (source):
https://www.youtube.com/watch?v=C_XeBAMlpYY
|
|
| |
|
