It is referred to as to consolidate data from multiple sheets into a master sheet.
1. Drag your mouse to select the cells corresponding to those in multiple sheets. Note: It would not work if you click the top-left corner box.
2. Date | Consolidate.
3. Click the icon under 'Reference'.
4. Go to the first data sheet, and drag-select all the cells. Click the icon again. Click 'Add'.
5. Go to the second data sheet, and repeat Step 4. Repeat until all the data sheets are done.
6. Click OK.
Done.
In addition to 'Addition', you can also do average, counting, max, min, product, etc.
Nice Article, all issue related with your computer Antivirus,data recovery, mail and security. We provide online instant technical solution. Call us toll free Kaspersky phone number number +1-877-2498558. For more information visit here:- Kaspersky phone number,
ReplyDelete123.hp.com/setup
ReplyDelete123.hp.com/envy7100
ReplyDelete123.hp.com/setup 6970
ReplyDeletewww.123.hp
ReplyDeletewww.hp./123
ReplyDeletewww hp.com/123
ReplyDeleteIf you searching for technical support for this software like TurboTax Support, Office.com/setup, AOL Desktop Gold, 123.hp.com/setup. Don’t need to worry visit here and resolve you all error immediately.
ReplyDeleteOffice.com/setup
TurboTax Customer Service Number
123hp.com/setup
AOL Desktop Gold