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.

=sumproduct(--(Month(A1:A200)=month(DateValue(M2&" 1, 2006"),B1:B200)

where M2 contains the dropdown and will display Jan or January as an
example.

--
Regards,
Tom Ogilvy


" wrote:

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.