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:
monaahmed2012 la Simpatie.ro
 | Femeie
25 ani
Calarasi
cauta Barbat
25 - 48 ani |
|
|
TRaP
Moderator
Inregistrat: acum 7 ani
Postari: 892
|
|
I want to sum all cells after the cell (to the right, adjacent) with some specific text, like "TOTAL VALUE".
All the complicated advanced Excel 365 have failed me.
This worked:
| =SUMIF(AM5:BD211; "TOTAL VALUE"; AN5:BE211) |
So you have desired range: AM5:BD211
And you go 1 column to the right: AN5:BE211
That's it.
Source: ChatGPT
|
|
| pus acum 13 zile |
|