Using a command button to SUM range of cells based on column OR sheet name

dgvalles

New Member
Joined
Jan 11, 2019
Messages
1
Hi there,

This might be a quick one for you geniuses out there. I'm a "longtime" lurker, first time poster.

Context:
The sheet is an individual's outreach report for our nonprofit clinic. Within the sheet, staff member records their categorized outreach numbers per month. Each month gets a sheet, and the total of January-December are totaled on a summary page.


I want to be able to:
1. Enter a starting and ending month and determine the sum of each category for the defined range of months.

For example, in cell Q3 I type in or select from drop down a month: January and in Q4 I type in or select March. I want the totals for each category spanning those months.

I didn't see an upload icon/section (maybe I'm a probationary user), but I'm willing to share my sheet. I'd love your help in figuring this out.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Please post your workbook for review.

You will need to use a cloud site like DropBox.com or similar.

Post the link
 
Upvote 0

Forum statistics

Threads
1,215,759
Messages
6,126,722
Members
449,332
Latest member
nokoloina

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top