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.

  • Please share a link to a copy of the spreadsheet, keeping in mind that we cannot see what you are seeing. This will be the only way for the volunteer contributors here to assess what is happening and suggest a solution. On the surface, what you are describing is not typical and may be due to an entry error that is trying to read e as the exponential math function; but there is no way to know without seeing it in context. The formula as shown in your post also doesn't make sense for row-by-row form processing, since it appears to be attempting to process a single column.
    – Erik Tyler
    Feb 10, 2022 at 18:22

1 Answer 1


Your formula is missing the multiplication operator (*) for the dollar bills.

The correct formula is:




  • That's what I was trying to do and the formula kept leaving out the * once I got to the $1 part like my example. For whatever reason, when I copied and pasted your formula it worked. I have no idea why it won't let me do it, but I appreciate your help. Feb 11, 2022 at 20:03
  • Such is life, eh. If this answer was good, then you might consider accepting it.
    – Tedinoz
    Feb 12, 2022 at 2:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.