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.
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.