See how to enter number of bills in deposit and quickly calculate the total for Bills Deposited using SUMPRODUCT function.…