![]() ![]() So it’s definitely shorter than something like ![]() This doesn’t look much shorter, but it’s pretty much the same size no matter how many cells are involved. One down side to this technique is that it won’t work on a range which is horizontal, only vertical, as this one is. Wow! That’s cool! Excel “finds” all the other Sum formulas and picks out the correct cells! Not likely to produce an error! But there’s no hunting for the correct cells to use. While the cell B38 is selected, press Alt/= (that is, hold the Alt key down and press the = sign). ![]() The first way is probably the easiest, but the formula is perhaps just as long. In this blog I’ll describe a few alternative ways to do this, leaving the best for last! It does work, producing the correct answer, but it’s tedious to do and certainly subject to errors because you might click the wrong cell. I’ve seen formulas like this many many times, and often a lot longer because the list is longer. How many of you would use the formula =B3+B9+B14+B20+B25+B32+B37 to solve the problem? The formula in cell B9, for example, is =SUM(B4:B8). Notice that there are several subtotals in the list. Suppose you have a worksheet which looks something like this:Ĭlearly, what’s needed is the grand total in cell B38. Still using long formulas to create grand totals in Excel? There is a better way! ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |