Hello,
We're not very Microsoft intelligent but I now have a need to digitize my business records and submit them to some government agency for the past two years or so. I need some help. We have created a table. The first row is set up as a header (we checked the check box when we created the table). In column F, we have the price we charged for parts. In column G, we have the price we charged for labor. In column H, we have the total (F+G).
Is there anyway to have Excel auto-calculate the total (column H) automatically without us having to type the formula each time? We know there's away to drag down the formula, but the problem is the number of rows change and although we can drag once we get all the data entered, we'd like a nice formula that didn't really depend on how many rows we had. For example, let's say tomorrow, I add a new row in the table for a new customer...after entering parts and labor, we'd like total to automatically populate without having to do anything. And then the next day, when we add yet another row, it auto-populates again. Any idea how we can accomplish this? Thanks!
We're not very Microsoft intelligent but I now have a need to digitize my business records and submit them to some government agency for the past two years or so. I need some help. We have created a table. The first row is set up as a header (we checked the check box when we created the table). In column F, we have the price we charged for parts. In column G, we have the price we charged for labor. In column H, we have the total (F+G).
Is there anyway to have Excel auto-calculate the total (column H) automatically without us having to type the formula each time? We know there's away to drag down the formula, but the problem is the number of rows change and although we can drag once we get all the data entered, we'd like a nice formula that didn't really depend on how many rows we had. For example, let's say tomorrow, I add a new row in the table for a new customer...after entering parts and labor, we'd like total to automatically populate without having to do anything. And then the next day, when we add yet another row, it auto-populates again. Any idea how we can accomplish this? Thanks!