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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Profil grecoaica
 | Femeie
22 ani
Dambovita
cauta Barbat
22 - 45 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
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):
|
|
| pus acum 1 an |
|