Count of Items for Google Sheets

[sprigelz]

Good afternoon,

I am attempting to create a count of the below table (Left). As you can see, some items have a - or // in them, and others do not.

I'd like to create a count of the "Type Extracted" basically anything before a special character ("-" or "/"). Results for this example are provided on the right side.

Type Original Creature - Goblin Soldier Creature - Goblin Berserker Creature - Goblin Enchantment Instant Artifact // Land Creature - Goblin Enchantment Legendary Artifact Legendary Creature - Goblin Warrior Sorcery Enchantment Land - Desert

Type Extracted Count Artifact 1 Artifact Creature Basic Land Creature 4 Enchantment 3 Instant 1 Land 1 Legendary Artifact 1 Legendary Creature 1 Legendary Enchantment Sorcery 1 Token Creature Tribal Enchantment

Any ideas on how I can create a count that excludes the special characters?

 

[ExceLoki]

this should get what you're looking for
-----------------

Book1
	A	B	C	D
1	Type Original		Type Extracted	Count
2	Creature - Goblin Soldier		Artifact	1
3	Creature - Goblin Berserker		Artifact Creature	0
4	Creature - Goblin		Basic Land	0
5	Enchantment		Creature	4
6	Instant		Enchantment	3
7	Artifact // Land		Instant	1
8	Creature - Goblin		Land	1
9	Enchantment		Legendary Artifact	1
10	Legendary Artifact		Legendary Creature	1
11	Legendary Creature - Goblin Warrior		Legendary Enchantment	0
12	Sorcery		Sorcery	1
13	Enchantment		Token Creature	0
14	Land - Desert		Tribal Enchantment	0
Sheet1

Cell Formulas
Range	Formula
D2:D14	D2	=COUNTIF($A$2:$A$14,""&C2&"*")

 

[sprigelz]

Looks good, the only problem in the real data is that it is counting both Artifact and Artifact Creature.

Don't see any other issues.

 

[Fluff]

Do you have the Textbefore function yet?
If so, how about

Fluff.xlsm
	A	B	C	D
1	Type Original		Type Extracted	Count
2	Creature - Goblin Soldier		Artifact	1
3	Creature - Goblin Berserker		Artifact Creature	0
4	Creature - Goblin		Basic Land	0
5	Enchantment		Creature	4
6	Instant		Enchantment	3
7	Artifact // Land		Instant	1
8	Creature - Goblin		Land	1
9	Enchantment		Legendary Artifact	1
10	Legendary Artifact		Legendary Creature	1
11	Legendary Creature - Goblin Warrior		Legendary Enchantment	0
12	Sorcery		Sorcery	1
13	Enchantment		Token Creature	0
14	Land - Desert		Tribal Enchantment	0
Main

Cell Formulas
Range	Formula
D2:D14	D2	=SUMPRODUCT(--(C2=TRIM(TEXTBEFORE($A$2:$A$14,{"-","//"},,,1))))

 

[sprigelz]

Do you have the Textbefore function yet?

Building this on Google Sheets currently. Doesn't look like that is a valid function.

 

[Fluff]

That is something that you have to clearly mention either in the title or in the initial post. Such questions should also be posted in the General Discussion & Other Applications section of the board.
I have done it for you this time.