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:
Profil irina_dragalasa

Femeie
24 ani
Bucuresti
cauta Barbat
26 - 65 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Sum All Cells After A Cell With Specific Text

Pagini: 1

Moderat de TRaP, TonyTzu

TRaP
Moderator
Postari: 960

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

Pagini: 1

Mergi la