View original (French)

[EXCEL] Sum of cells that do not contain p

Solved
saiyuke Posted messages 29 Registration date   Status Membre -  
saiyuke Posted messages 29 Registration date   Status Membre -
Hello,

Please, I would like to know the formula to sum my column "A" but that does NOT contain the word "boat"...

I've tried many methods but apparently, I'm too much of a beginner:

Here is my formula:

=SUM(A2:A65536<>"ABC")

But the problem is that it sums the cells that are NOT EQUAL to "ABC"... What I would like is to sum the cells that do NOT CONTAIN "ABC"...

Thank you in advance if you have time for me :'(

4 réponses

Réponse 1 / 4
leplot Posted messages 191 Registration date   Status Membre Last intervention   131
 
Hello

If you're looking for the number of cells:
=COUNTIF(B1:B6,"<>*abc*")

If you want the sum of column A when column B does not contain "abc"
=SUMIF(B1:B6,"<>*abc*",A1:A6)

--
LePlot
_________________________________________________________________
Don't forget to mark the status as Resolved when the solution has been found. Thank you
20