Extract only currency value from a string

[78459430]

$10,000 received on 10/10/2023
$500 received on 10/10/2023	Total received on 10/10/2023 is $10,500
$1,500 received on 11/10/2023
$1,000 received on 11/10/2023	Total received on 11/10/2023 is $2,500
$50 received on 12/10/2024
$150 received on 12/10/2024	Total received on 12/10/2024 is $200
$500 received on 15/10/2024
$200 received on 15/10/2024	Total received on 15/10/2024 is $700

Hi,
I would need the formulas on column B to read the exact date and SUM only the currency value ($xxxxxxx) shown on column A.
Please help

Thank you!

 

[78459430]

I would recommend against typing the date in the formula & suggest putting it in cell then using the formula to reference that cell as shown in B2:C3 below.
If you really must type it in the formula I have given an example in cell C5.

If this is still not what you want please post new sample data with the exact result(s) that you want (preferably with XL2BB ) and explain again in relation to that specific sample data.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

25 03 26.xlsm
	A	B	C
1	Data	Date	Result
2	$10,000 received on 10/10/2023	11/10/2023	Total received on 11/10/2023 is $2,500
3	$500 received on 10/10/2023	5/10/2023	Total received on 5/10/2023 is $0
4	$1,500 received on 11/10/2023
5	$1,000 received on 11/10/2023		Total received on 10/10/2023 is $10,500
6	$50 received on 12/10/2024
7	$150 received on 12/10/2024
8	$500 received on 15/10/2024
9	$200 received on 15/10/2024
Sum by date (3)

Cell Formulas
Range	Formula
C2:C3	C2	=LET(d,TEXT(B2,"d/mm/yyyy"),"Total received on "&d&" is "&TEXT(SUM(--FILTER(TEXTBEFORE(A$2:A$9," "),TEXTAFTER(A$2:A$9," ",-1)=d,0)),"$#,##0"))
C5	C5	=LET(d,"10/10/2023","Total received on "&d&" is "&TEXT(SUM(--FILTER(TEXTBEFORE(A$2:A$9," "),TEXTAFTER(A$2:A$9," ",-1)=d,0)),"$#,##0"))

This works!!! but I have one last question: the dates are between round brackets, so the last character is a round bracket.

$10,000 received on (10/10/2023)	Result
$500 received on (10/10/2023)	Total received on 10/10/2023 is $10,500
$1,500 received on (11/10/2023)
$1,000 received on (11/10/2023)
$50 received on (12/10/2024)
$150 received on (12/10/2024)
$500 received on (15/10/2024)
$200 received on (15/10/2024)

Thanks.

 

[Peter_SSs]

78459430.xlsm
	A	B
1	Data	Result
2	$10,000 received on (10/10/2023)	Total received on 10/10/2023 is $10,500
3	$500 received on (10/10/2023)
4	$1,500 received on (11/10/2023)
5	$1,000 received on (11/10/2023)
6	$50 received on (12/10/2024)
7	$150 received on (12/10/2024)
8	$500 received on (15/10/2024)
9	$200 received on (15/10/2024)
Sum by date (4)

Cell Formulas
Range	Formula
B2	B2	=LET(d,"10/10/2023","Total received on "&d&" is "&TEXT(SUM(--FILTER(TEXTBEFORE(A$2:A$9," "),TEXTAFTER(A$2:A$9,"(",-1)=d&")",0)),"$#,##0"))

 

[78459430]

=LET(d,"10/10/2023","Total received on "&d&" is "&TEXT(SUM(--FILTER(TEXTBEFORE(A$2:A$9," "),TEXTAFTER(A$2:A$9,"(",-1)=d&")",0)),"$#,##0"))

This is it! Thanks.

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.