VBA to sum dynamic row and column

[YOHANIS]

Hi all

Any idea on how to sum dynamic excel column and rows (where the size of the data varies from file to file)

In addition, Using the same result (say the column Sum list) , I would like to count those between say 100 and 150 and show their percentage on a new excel sheet.
The original data which produced the column sum is on another sheet.

Please see the example on the new excel sheet where i am hoping to get
Thank you in advance.

SUM​
125​
120​		Percentage between 100 and 150 is 28.5%
86​
52​
25​
99​
253​

 

[YOHANIS]

Hi all

Any idea on how to sum dynamic excel column and rows (where the size of the data varies from file to file)

In addition, Using the same result (say the column Sum list) , I would like to count those between say 100 and 150 and show their percentage on a new excel sheet.
The original data which produced the column sum is on another sheet.

Please see the example on the new excel sheet where i am hoping to get
Thank you in advance.

SUM​
​ 125​
​ 120​		Percentage between 100 and 150 is 28.5%
​ 86​
​ 52​
​ 25​
​ 99​
​ 253​

Here is a bit clarification and sample excel file attached.
So, the first step i have a problem is how to generate those "Sum" values from the other sheet called "Data" and place them where they are now on "Sheet1"
The column and rows data size on the "Data" sheet changes from time to time. The percentage part comes later once the data on column A is extracted
Thank you

 

[vletm]

YOHANIS​

Do Data-sheet has always A-column and 1st row like in Your sample file - skip calculation?
Your say 100 and 150 - are those fixed?
... if something else then - how to set those?

 

[YOHANIS]

YOHANIS​

Do Data-sheet has always A-column and 1st row like in Your sample file - skip calculation?
Your say 100 and 150 - are those fixed?
... if something else then - how to set those?

Thanks vletm
Yes data - sheet will also have column A (userId) and the 1st row (row 1) is also holding the title. No skip calculation. Also the number 100 and 150 are not fixed it just an example and it changes from time to time.
thanks again

 

[vletm]

YOHANIS​

Fixed - I skipped A-column and the 1st row.
How - Select Data-sheet's cell A1 and apply limits to get results.
Between - eg 100 ... 150, including those values

 

[p45cal]

Cross posted http://www.vbaexpress.com/forum/showthread.php?70962-Summing-dynamic-Excel-column-and-count

 

[vletm]

YOHANIS​

Please, reread Forum Rules - those are for You too:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
  
• If you post a question, check the answers and acknowledge the answer if correct or incorrect. We get a lot of posts with 1 answer and no feedback, so we're unsure if the answer is right or wrong or if the poster has even bothered to read the answer.
• Remember people are volunteering their time to help you. Always show them the courtesy they deserve by checking and responding to answers.

 

[YOHANIS]

Sorry for cross posting
[SOLVED) @ http://www.vbaexpress.com/forum/showthread.php?70962-Summing-dynamic-Excel-column-and-count