00:00To calculate the final total of the spreadsheet, you can either add up all the subtotal like this,
00:04alternatively you can actually add up all the line item excluding the subtotal and you can get it.
00:09But as you can see, this task can be dauntingly difficult if there are hundreds or thousands of
00:14rows. Never than last, like anything else in Excel, there's a smarter way to do this,
00:17and this is how you do it. The formula we'll be using is called SUMPRODUCT,
00:22and the first argument on SUMPRODUCT would be everything on that particular column itself,
00:27including the tax and the subtotal and everything. And the second argument will be using a double
00:32unary operator, and we're going to check if that particular cell is a formula, and we're going to
00:37select everything including the tax and the subtotal itself. If the cell is a formula, the cell value
00:42will be multiplied by 1. If it's not, the cell value will be multiplied by 0, and the results are all
00:48added up together.
Comments