Help with Sumif formula

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SumIF with an array 3
help with sumif formula 3
Excel Excel: How do I put a formula in a drop down list 11
Column Heading Loop 2
Set value of cell to calculation 1
Copying selected rows into new worksheet 2
VBA code 1
SUMIF with NAME RANGE 1

Top