Take $ amounts from filenames & total them in a text file?

I don't even know if something like this is possible, but if anything can do it, it would be Hazel.

I have invoices and receipts sorted into various categories. The amount of the invoice or receipt is included in the filename. I would like to automate the process of grabbing the dollar amounts from the filenames and have them added and totalled in a text or CSV file for easy importing into Excel.

I just need to point Hazel at a folder of PDFs with dollar amounts in the filenames and have Hazel create a simple text or CSV file that lists the dollar amounts with a sum total at the bottom.

Is this possible? If so, how would I go about doing it?

That would require a custom script to do. While you can possibly grab the value of the filenames, Hazel doesn't do any sort of arithmetic so you'll have to do some sort of script to do that part.