Sumproduct on date range
 

I need to sum the Invoice Amount for each Account # for each Month. My data
is formatted as below:

A B C
Date Account # Invoice Amount
4/15/2008 1234 $100
4/15/2008 5678 $200
4/30/2008 1234 $100
5/1/2008 1234 $100
5/2/2008 5678 $500

So, for April I have a total of $200 for account # 1234. I can't quite get
the formula to work with the dates. Any help is appreciated. Thanks

Sumproduct on date range
 

=SUMPRODUCT((MONTH(A2:A6)=4)*(A2:A6<"")*(B2:B6=12 34)*C2:C6)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Southpaw" wrote in message
...
I need to sum the Invoice Amount for each Account # for each Month. My
data
is formatted as below:

A B C
Date Account # Invoice Amount
4/15/2008 1234 $100
4/15/2008 5678 $200
4/30/2008 1234 $100
5/1/2008 1234 $100
5/2/2008 5678 $500

So, for April I have a total of $200 for account # 1234. I can't quite
get
the formula to work with the dates. Any help is appreciated. Thanks

Sumproduct on date range
 

Works great. Thanks a bunch!

"Sandy Mann" wrote:

=SUMPRODUCT((MONTH(A2:A6)=4)*(A2:A6<"")*(B2:B6=12 34)*C2:C6)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Southpaw" wrote in message
...
I need to sum the Invoice Amount for each Account # for each Month. My
data
is formatted as below:

A B C
Date Account # Invoice Amount
4/15/2008 1234 $100
4/15/2008 5678 $200
4/30/2008 1234 $100
5/1/2008 1234 $100
5/2/2008 5678 $500

So, for April I have a total of $200 for account # 1234. I can't quite
get
the formula to work with the dates. Any help is appreciated. Thanks

Sumproduct on date range
 

You're very welcome. The (A2:A6<"") will only be requires if there is a
possibility that you may have empty cells because an empty cell will be
treated as bein the month of January. The (A2:A6<"") prevents this
happening.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Southpaw" wrote in message
...
Works great. Thanks a bunch!

"Sandy Mann" wrote:

=SUMPRODUCT((MONTH(A2:A6)=4)*(A2:A6<"")*(B2:B6=12 34)*C2:C6)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Southpaw" wrote in message
...
I need to sum the Invoice Amount for each Account # for each Month. My
data
is formatted as below:

A B C
Date Account # Invoice Amount
4/15/2008 1234 $100
4/15/2008 5678 $200
4/30/2008 1234 $100
5/1/2008 1234 $100
5/2/2008 5678 $500

So, for April I have a total of $200 for account # 1234. I can't quite
get
the formula to work with the dates. Any help is appreciated. Thanks