T
twlove
I have a worksheet with two tables. The first table includes several
rows of monthly transactional data including Column A - Order date (mm/
dd/yy date format), Column B Gross Sale Amount (currency format),
etc. In a separate 'Summary Table' I created a drop down list that
allows me to select the month I wish to report on. Let's say I select
January from the drop down list. I want my summary table to return
the total gross sales for transactions recorded in January only. When
I select February from the drop down, I want to see totals for
February transactions only, etc.
Any help in constructing the proper formula wiuld be greatly
appreciated!
Thank you.
rows of monthly transactional data including Column A - Order date (mm/
dd/yy date format), Column B Gross Sale Amount (currency format),
etc. In a separate 'Summary Table' I created a drop down list that
allows me to select the month I wish to report on. Let's say I select
January from the drop down list. I want my summary table to return
the total gross sales for transactions recorded in January only. When
I select February from the drop down, I want to see totals for
February transactions only, etc.
Any help in constructing the proper formula wiuld be greatly
appreciated!
Thank you.