Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct between date range | Excel Worksheet Functions | |||
Can a date range be used in SUMPRODUCT | Excel Worksheet Functions | |||
SUMPRODUCT between date range | New Users to Excel | |||
Sumproduct with date range | Excel Worksheet Functions | |||
SUMPRODUCT with date range question | Excel Discussion (Misc queries) |