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:
mary24 la Simpatie.ro

Femeie
24 ani
Braila
cauta Barbat
25 - 56 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: 960

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&"*")

Pagini: 1

Mergi la