Adding (subtraction etc) in cell

Katipai · ‎April 23, 2019

Switching from desktop to online. Is there a way to do the simple addition of numbers in cell? I found a youtube tutorial which showed how to do it in the Amount cell on an invoice, but it doesn't seem to apply to bills or journal entries.

For example, I'm wanting to split a bill into various subcategories ... in desktop I could add $5.97 + $8.63 + $2.00 in the cell related to the line item and it would total it up for me. Is there a way to do this online?

IamjuViel · ‎April 23, 2019

Pleased to have you here, @Katipai.

I'd be delighted to help walk you through on how to enter a line item on your invoice and bill in QuickBooks Online.

When adding a line item on an invoice or bill, you can enter it one by one. However, if you need to add or change the rate of the line item, yes, you can add or subtrct on the same cell. But it will not automatically create a new line item.

If you're referring to putting a sub-line item under a specific item to indicate a group or packages, you can utilize our QuickBooks Online Bundle feature.

You may check the video below for reference:

Looking forward to seeing your post here in the Community if you have other questions about creating an invoice and bill in QuickBooks Online. I'm always here to answer your inquiries.

View solution in original post

IamjuViel · ‎April 23, 2019

Pleased to have you here, @Katipai.

I'd be delighted to help walk you through on how to enter a line item on your invoice and bill in QuickBooks Online.

When adding a line item on an invoice or bill, you can enter it one by one. However, if you need to add or change the rate of the line item, yes, you can add or subtrct on the same cell. But it will not automatically create a new line item.

If you're referring to putting a sub-line item under a specific item to indicate a group or packages, you can utilize our QuickBooks Online Bundle feature.

You may check the video below for reference:

Looking forward to seeing your post here in the Community if you have other questions about creating an invoice and bill in QuickBooks Online. I'm always here to answer your inquiries.

Katipai · ‎April 23, 2019

Thanks ... I realized that the issue was that I was hitting enter expecting the sum to appear as it would in the desktop version. The solution here is to move to the next cell, in my case the easiest way is by arrowing up or down, which is contrary to how it behaved in my previous version. New muscle memory!!

HNewland · ‎May 21, 2019

Thank you! This was driving me crazy.

poormetea · ‎February 11, 2020

Thank you!! I was struggling with the same issue...kept hitting enter. Appreciate this.

gsquaredb · ‎April 13, 2022

so if i want to add amounts in the amount column of a check e.g. add all my gas purchases into 1 category from my credit card statement. If i try use the + it say "this value is out of range". Enter doesnt work or do the arrow keys.

katherinejoyceO · ‎April 13, 2022

Thanks for sharing your first concern in this thread, @gsquaredb. This issue usually happened when cache and cookies are full.

You'll want to access your QBO company using an incognito or private window to rule out this problem. Here are the shortcut keys:

Ctrl + Shift + N for Google Chrome
Ctrl + Shift + P for Firefox & Microsoft Edge
Command + Shift + N for Safari

If that works, go back to your regular browser and start clearing its cache to improve your browsing experience.

You may also switch to other supported browsers to further isolate the issue.

Additionally, I've included our QuickBooks Online Articles for future reference.

Visit us again for your other concerns. I'll be around to guide you again.

LindsaySB1185 · ‎April 19, 2024

Yes, thank you. that is so not intuitive. I was about to go crazy thinking I had to use a calculater everytime I needed to add while in a cell box.

chenais · ‎June 05, 2024

I still do not see where the instructions are, can someone please write in the comments what the process is? Thank you

Rainflurry · ‎June 05, 2024

@chenais

For addition, type 12.34+56.78<tab>

For subtraction, type 12.34-56.78<tab>

For multiplication, type 12.34*56.78<tab>

For division, type 12.34/56.78<tab>

Topics

Training

Community

Resources

Adding (subtraction etc) in cell