In Excel 2003, choose Consolidate from the Tools menu. Click the Data tab and then click Consolidate in the Data Tools group.I’ll select A1 in another sheet (named ByDate), but you can select another area of the same sheet. Position the cursor in the top-left corner of the subtotal range (where Consolidate will display the subtotals).Now you’re ready to use the Consolidate feature to subtotal the sold values by date, as follows: ![]() With the data range selected, enter CByDate (consolidate by date) in the Name Box – that’s the small control above the top-left corner of the sheet and to the left of the Formula Bar (circled above).Click anywhere inside the data range and press ++8.The only setup task left is to name the data range using your favorite technique, or as follows: In this case, the data meets the first two conditions listed above. ![]() Specifically, let’s find the subtotal for each date. Let’s use the simple data range shown below to illustrate the Consolidate feature. You must assign a range name to the columns you’re summarizing.The data range must have headings for each column.The values you’re summarizing by must be to the left of the values you’re summarizing.When the data range accommodates the following rules, it’s probably the quickest way to summarize data: ![]() You can also use it to quickly summarize data in a single sheet – without sorting the data.Ĭonsolidate is simple to use but requires a bit of initial setup. But don’t cross this feature off your list because it sounds like something you don’t need. It’s a great tool for combining data when several users work with different instances of the same file. There are a number of ways to summarize Excel data, but Consolidate is one of the easiest to implement and the results are easy to use.Įxcel’s Consolidate feature’s claim to fame is merging and summarizing values from multiple workbooks. Use Consolidate to summarize Excel data without sorting
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |