Tags: GET.WORKBOOK

Sum data from a particular cell of last n sheets only

{ 0 Comments }

By Ashish Mathur · February 25, 2013 · DATA SUMMARISING · Leave a comment

A number is entered in cell A1 of every sheet in a multi sheet workbook. The task is to sum numbers in cell C2 of the Summary sheet from cell A1 of last x sheets – x is the number of sheets (mentioned in cell B2 of the Summary sheet) from which numbers have to be summed […]

LinkedIn
Facebook
Twitter
Email

Linkedin0 Facebook0 Email0 Twitter0

Search for:

Recommendations from LinkedIn

I’ ve been part of the training program that Ashish had conducted at our organisation. I found the sessions to be extremely useful for my day to day work and Ashish was exemplary in the way he conducted these sessions. Very practical, systematic and enforcing, the examples provided were of utmost relevance. I have no hesitation in recommending Ashish’s training programs.

Santosh Kumar Peshkar

I knew excel but after attending the session from Mr. Ashish I was ablt to identify new avenues of using the same function which I was not aware off and tremendous application of the same. It is awesome to see how he conduct the session too. God Bless Him!

Vishal Goel

Ashish Mathur is an expert in Excel with amasing knowledge on the subject. HIs conceptual knowledge and the way he provides the excel training shows how in depth he has researched on the subject. Always interested to find the best approach to a problem he shows a “nothing is impossible” attitude. Way to go and thanks a lot for the useful training.

Shruti Gupta

Ashish Mathur is on the of Best Excel Expert that i have come across in my life. I met him once in our Corporate traning session on excel. He truely surprised me by his skills on Excel. His method of explaining the excel techniques was also impressive. The whole batch praised about that excel session. All that i can say that i will always be in touch with you “Ashish Mathur, Sir”

CA.Amandeep Singh Sabharwal

It was a two day session at Quatrro where Ashish trained people from diverse work profiles about Advanced Excel Techniques. The expertise, he posses regarding his subject matter and the preciseness with which he handled the queries of attendees, is really adorable. He is doing a good job by creating awareness among people about undiscovered excel functions, which can seriously reduce time and efforts for daily excel users. I wish him best of luck for his future…

Gunjan Gupta, ACA