I have created a Google Form for cashiers to balance out their cash drawers at the end of each day. Currently I have the form set so that they only have to count the amount of each coin/bill and not the $ amount. Their answers are logged on a spreadsheet.
I would love to create a formula that computes the $ amount and totals it up. Problem is, when I try to do this my formula is too long for what google allows. Is there a better formula for this type of computing. Formula I am trying to use is: sum(e5*.01,e6*.05,e7*.10,e8*.25,e91,e105,e1110,e1220,e1350,e14100) As you can see, once I get to e9 the formula is distorted and no longer registers the multiplication.
I have also tried totaling up each row into cells on a separate sheet, then doing sum formula of those cells, but ideally this is something I need to reproduce 365 times and am looking for a less time consuming method.