Help with Sumif formula
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. |
Help with Sumif formula
=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. |
All times are GMT +1. The time now is 02:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com