How to add a column then figure sales tax?

"both of those" are the same. Csound has described what to do. FoxFirth has shown an example of a formula that does what Csound described.

Here's an example using the same formula is cell D10 to calculate the tax included sum of the values in cells D2 to D7. (The Numbers 3 version will show a small x where this shows an asterisk.)

Click on the cell containing your formula. The cells referenced by SUM() should display the same colour fill as the colour in the lozenge showing the range definition (D2:D7). If this is not true in your case,Numbers is not recognizing what you've entered as a formula.

You can also calculate the total before tax (shown in D8), the tax due in that total (shown in D9), and the tax-in total by summing those two values. For this method, use these three formulas:

D8: =SUM(D2:D7)

D9: =D8*6% OR =D8*0.06

D10: =D8+D9

chfurlong78 wrote:

there a way to do this if column E is a checkbox and I only want the totals in column D to be included in the sum if the box in column E is checked?

Here is how you can do that:

Rows 8 through 10 are defined as Footer Rows (you do that via the dropdown beside the row numbers at the left).

The formula in D8 is:

=SUMIF(E,TRUE,D)

The formula in D9 is:

=D8×6%

The formula in D10 is:

=D8+D9

If you're having trouble getting anything other than 0 in your original formulas go to File > New and open up the 'Invoice' template in the Business section to see a working example. Very likely you don't have the sum range right (maybe no numbers in E8:E12?) so Numbers thinks the sum is 0 and is multiplying that by the % you specify, for which the result is of course 0.

SG

"I know. But I can't figure out what is wrong!"

Perhaps copying that formula and pasting it (rather than typing it) here might help determine why the result is zero. A screen shot of the table with the cell containing the formula selected could also be useful.

Regards,

Barry

And, apropros of nothing at all… 😕

So do you have a table named 'Expenses' and in that table do you have values you want to sum in cells E8:E12? Maybe you meant cells in another column, D perhaps? Did you try the examples posted above, exactly as shown?

To post a screenshot you can follow Wayne's instructions here.

SG

Csound1 wrote:

And neither can I but I do know that anything multiplied by a number greater than 1 gets bigger in the process.

Not sure your comment helps the OP, or the cause of basic numeracy. Does 0 multiplied by a number greater than 1 get bigger in the process?🙂

SG

"SUM(Expenses::E8:E12)×0.06

That ^^ as with the other is copy and paste. I did not type it out."

But that ^^ 's the one that is working, not the one with 1.06 that's giving the zero result.

Best would be a screen shot of the table with the zero result cell selected, showing all cells highlighted because they are referenced by the formula, and including the entry box, where the formula itself can be seen.

Regards,

Barry

Multiply the total by 1.06, that will add 6%

Using the example of the column being B2 through B5: SUM(B2:B5)×1.06

chfurlong78 wrote:

Using the *1.06 it always came out to 0.

Then you have a problem, anything multiplied by 1.06 will become larger than it was it will NOT be zero, you have another issue.

And neither can I but I do know that anything multiplied by a number greater than 1 gets bigger in the process.

You know the answer to that one already, why not show us.