How to Calculate sales tax properly from a column of items

[Bond00]

I want to be able to get the totals and correct tax from this.
Really I just need a formula for getting the correct tax value.

assume these values are A1 through A12
$2,993.97
$5,492.30
$7,263.92
$4,759.96
$679.96
$1,119.96
$3,914.95
$820.99
$1,183.99
SubTotal: =SUM(A1:A9)
Tax: ???
Total: =A10+A11

 

[Bond00]

It's most likely because those blank cells aren't truly blanks. Try =ISBLANK() on "empty" cells and what does it return?

yeah thats it result was FALSE, very odd, the cell is actually blank because when I click on it to edit it and click off it, it then becomes true so nothing was in it. I try to select something and nothing is there not even a space. So yeah just weird. What can i type as a formula to see what's actually in that cell? Or what it thinks is there..

 

[Cubist]

yeah thats it result was FALSE, very odd, the cell is actually blank because when I click on it to edit it and click off it, it then becomes true so nothing was in it. I try to select something and nothing is there not even a space. So yeah just weird. What can i type as a formula to see what's actually in that cell? Or what it thinks is there..

Try =UNICODE()

 

[Bond00]

Try =UNICODE()

It just gave a #VALUE! error same as if there was nothing in there