"countifs" if its not (how to count everything except one value)

**DeadPool_M** · 10-06-2021, 12:55 PM

if I want to count everything except one value, how can I do that?

*I tried to use with "not" function but its not works so well...

Tnx for your help

**DeadPool_M** · 10-06-2021, 01:32 PM

I found the answer

**wk9128** · 10-07-2021, 12:35 AM

@DeadPool_M The formula should be written like this, otherwise the blank will count

HTML Code:

"countifs" if its not (how to count everything except one value)

LinkBack

Thread Tools

Rate This Thread

Display

"countifs" if its not (how to count everything except one value)

Re: "countifs" if its not (how to count everything except one value)

Re: "countifs" if its not (how to count everything except one value)

Thread Information

Users Browsing this Thread

Similar Threads

Countifs with a "findlist" to find items in one list, but exclude items in "exclusions"

Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas

[SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"

[SOLVED] COUNTIFS returning "TRUE" or "FALSE"

Excel formula "COUNTIFS" problem with ">"

[SOLVED] Possibly Easy: Making an "Other" with Countifs; "Not this, this, or this"

COUNTIFS with a column containing the words "true" and "false"

Bookmarks

Bookmarks

Posting Permissions