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:
Ioanacatalina

Femeie
25 ani
Salaj
cauta Barbat
25 - 61 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 Range if Cells Do Not Contain Text [SUMIFS]

Pagini: 1

Moderat de TRaP, TonyTzu

TRaP
Moderator
Postari: 964

I just want to sum up values in a column corresponding to cells in another column that do not contain a certain text.

=SUMIFS(SUM_RANGE;CRITERIA1_RANGE;CRITERIA1;CRITERIA2_RANGE;"<>*TEXT*")

If that text is in a cell, this can become:

=SUMIFS(SUM_RANGE;CRITERIA1_RANGE;CRITERIA1;CRITERIA2_RANGE;"<>*"&D3&"*")

Topicuri similare

Pagini: 1

Mergi la