If you add a Currency Field within your table with your price within it. Airtable will show a SUM at the bottom of the page calculating the total amount of all records displayed. If a filter where added it would show total amount of filtered records,...

If you could post the code JSON code which you used to connect to airtable, I am sure many people would be able to benefit from this and be able to produce some brilliant reports and documents. I for one would be very interested in this. Thanks Gary