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: Naturesk din Bucuresti
| Femeie 25 ani Bucuresti cauta Barbat 25 - 47 ani |
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
Source:
Sum if cells begin with specific number: Sums B2:B13 if first 4 characters of cells in range A2:A13 are 2017.
=SUMPRODUCT((LEFT(A2:A13;4)+0=2017)*(B2:B13))
Sum if cells begin with specific text: Sums B2:B13 if first 3 characters of cells in range A2:A13 are KTE.
=SUMIF(A2:A13;"KTE*";B2:B13)
This can also be done using a formula for the text string to search in A2:A13. Assuming KTE is in cell D2, KTF in D3 etc., you can drag the following formula from E2 downwards:
=SUMIF($A$2:$A$13;D2&"*";$B$2:$B$13)
Modificat de TRaP (acum 5 ani)
|
|
pus acum 5 ani |
|