Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
K
Katipai
April 23, 2019
Solved

Adding (subtraction etc) in cell

  • April 23, 2019
  • 1 reply
  • 0 views

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?

Best answer by IamjuViel

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.

1 reply

IamjuViel
IamjuVielAnswer
Level 8
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.

K
KatipaiAuthor
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!!

    H
    HNewland
    May 21, 2019

    Thank you!  This was driving me crazy.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement