VLOOKUP & INDEX MATCH in Excel. In this example, the Summary tab contains three divisions and we want to retrieve the Invoiced amount from their respective tabs based on the Month selected on cell B4. The data in the Division tabs are arranged in a simple way where it indicates the Invoiced amount for each month. After a field has been added to the pivot table, to select a different summary function, follow these steps: Right-click on a cell in the Value field that you want to change. In the pop-up menu, click Summarize Values By. Click on the Summary Function that you want to use.
I am having problem in crating a loop to have summary on my table data.To make my question clear refer to below image.
Thank you in advance.
Brandon Jake SullanoBrandon Jake Sullano
1 Answer
This is probably massively overkill but will be quick if you've got a large data set that you're working on (which I'm guessing you are otherwise you could do this easily by hand or using a pivot table). Please have a look at the comments and update where stated. It will currently output to cell E2 on the activesheet but I recommend updating ActiveSheet to your actual sheet name and E2 to your desired location
TomTom
Not the answer you're looking for? Browse other questions tagged excelvbaexcel-vba or ask your own question.