Counting rows that don't contain a specific value.

[pikola]

Hi everyone,

I have a question. I wanted to count rows that don't contain letter B. In my sheet I have products with diffrent letters.
These are A, B, C and D.

I would like to count rows in a column that contain these values, all rows apart from theese which contain letter A.
I waned to use COUNTIFS(). Just like here:

COUNTIFS(D35:D450; not("A"))

But it doesn't work. Can I do that in one formula?

Thanks a lot!

[Sam Capricci]

if you want to count those w/o A in that column try it this way... =COUNTIF(D35:D450;"<>A")

[Sam Capricci]

BTW, that will count blanks within that range as also not A.

[TMS]

I wanted to count rows that don't contain letter B.

And

I would like to count rows in a column that contain these values, all rows apart from theese which contain letter A.

There seems to be some contradiction.

[TMS]

If you want to be specific:

Please Login or Register  to view this content.

[HansDouwe]

Please attach a sample workbook (see yellow banner) with expected results.
Then you have a better chance that we will interpret you correctly.

[sandy666]

maybe with Power Query

source		Count
blablaAbla		6
kotukoD
whateCver
mayBe
skyDrive
America
Europe
Africa
Asia
NeZealand

Please Login or Register  to view this content.