Pivot table

[normpam]

Is it possible to get a Pivot table to summarize sums based on text within cells. Such as:
TfgyytCostcoggy. $560
GyygTargetyttt6. $200
Yg5Costcohyy5. $450

to get sums of all entries that contain Target or Costco?

 

[DanteAmor]

One option is to divide the text into columns with the following formulas:

varios 03dic2021.xlsm
	A	B	C	D	E	F
1	Text	Concept	Value		Pivot:
2	TfgyytCostcoggy. $560	Costco	560		Concepts	Sum Value
3	GyygTargetyttt6. $200	Target	200		Costco	1010
4	Yg5Costcohyy5. $450	Costco	450		Target	200
5					Total	1210
Hoja4

Cell Formulas
Range	Formula
B2:B4	B2	=IF(ISNUMBER(SEARCH("Costco",A2)),"Costco",IF(ISNUMBER(SEARCH("Target",A2)),"Target",""))
C2:C4	C2	=MID(A2,FIND("$",A2),99)+0