Count cells but exclude 2 values

Hi

I have a list of 19 items in column D, i want to count them but exclude 2 specific items "Bags" and "Shoes"

I've tried a couple different ways but I can't get it to work.

I am using the range D:D as there will be more items added to the list

Maybe something like this...

=COUNTA(D:D)-SUM(COUNTIF(D:D,{"Shoes","Bags"}))

Perhaps

=SUMPRODUCT(--(ISTEXT(D:D)), --(D:D <> "shoes"),--(D:D <>"bags"))

You're welcome. Thanks for the feedback!

I think

=COUNTIF(F:F, "Return")- SUM(COUNTIFS(D:D,{"Shoes","Bags"}, F:F, "Return"))
as you'd only want to subtract shoes and bags that were returned

Originally Posted by Karen13

Would I also be able to add to =COUNTA(D:D)-SUM(COUNTIF(D:D,{"Shoes","Bags"})) where column F must contain the word "Return"?

Maybe this...

Data Range

	D	E	F
1	Item	------	Status
2	shoes		stock
3	bags		return
4	cans		return
5	flowers		ship
6	gowns		return
7	shoes		ship
8	bags		stock
9	hats		return
10
11
12
13
14
15

=SUMPRODUCT(--(D2:D15<>""),--ISNA(MATCH(D2:D15,{"Shoes","Bags"},0)),--(F2:F15="Return"))

Result = 3

Originally Posted by ChemistB

Perhaps

=SUMPRODUCT(--(ISTEXT(D:D)), --(D:D <> "shoes"),--(D:D <>"bags"))

Ouch! Not with entire column references, though!