![]() You do not need to have created the total.Īt the bottom right, you will see the Quick Analysis button. ![]() Provided you have Excel 2013 or a later version than that, you can save the effort of using formulas by using the Quick Analysis tool.Įnsure you have a spare column next to the data for the answers to be inserted. Similarly for cumulative totals, you would have to create the relevant formula. To calculate % of Totals in Excel, you would normally have to use absolute cell references or name the Total cell.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |