Using Sum Function how to sum only the number if joined text as its own criteria

[Lacan]

Hi Guys,

Here´s the challenge using Sum Function how to sum only the number if joined text as its own criteria.

Accordingly with table below the goal its to sum only numbers joined with letter "A" so sum the numbers in customers columns like: "1A"; "3A" and "2A" which result will be 6.

Thank you very much guys.

CUSTOMER	PRODUCT
XPOT	1A
BILLA	6
APPLE	3A
JOHN	2
PROD	4
YAN	2A
KLM	10
TOTAL

 

[Fluff]

How about

+Fluff 1.xlsm
	J	K
1	CUSTOMER	PRODUCT
2	XPOT	1A
3	BILLA	6
4	APPLE	3A
5	JOHN	2
6	PROD	4
7	YAN	2A
8	KLM	10
9	TOTAL	6
Lists

Cell Formulas
Range	Formula
K9	K9	=SUM(FILTER(--SUBSTITUTE(K2:K8,"A",""),RIGHT(K2:K8)="A"))

 

[Joe4]

I am not as quite as proficient as Fluff at some of the newer functions, like Filter, so I resorted to the old SUMPRODUCT method, i.e.

=SUMPRODUCT(--(RIGHT(B2:B8,1)="A"),--(SUBSTITUTE(B2:B8,"A","")))

 

[Lacan]

@Fluff & @Joe4

Thank you very much Guys.???

Wish all the best 4 u. ??

 

[Fluff]

Glad we could help & thanks for the feedback.