Hi All,
I am using Excel 2013
I have records (month & year wise) for 3 vendors at 3 different sheets, in tabled format.
In summary sheet like to summarize data with 3 way selection. (Month, Year and Vendor)
I had done it with Month and Year for Each vendor (Sheet1, sheet 2, Sheet3) but unable to add 3rd criteria.
Please help
I am using Excel 2013
I have records (month & year wise) for 3 vendors at 3 different sheets, in tabled format.
In summary sheet like to summarize data with 3 way selection. (Month, Year and Vendor)
I had done it with Month and Year for Each vendor (Sheet1, sheet 2, Sheet3) but unable to add 3rd criteria.
Please help