please tell me do i have to do it manually for each invoice, or if their is any easy formula that it calculates for all customers in excel as i have invoice data of more than 1000 customers per month and doing it manually for each customer/ invoice is not practically possible

or if it is possible in quickbooks to final total number of quantity sold to customer and not for each single invoice as mostly customer have single invoice in month and it will save my time