Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals based on meeting multiple criteria
I have a sheet that looks something like this:
Date New Old 1/1/06 10 1/5/06 5 5 1/8/06 20 1/8/06 15 5 How do I get a total for New and old between specific dates? For example, dtotal New between 1/1/06 and 1/5/06? Thanks -- JerryS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals based on meeting multiple criteria
something like this
=sumproduct((a3:a22=a1)*(a3:a22<=a2)*b3:b22) -- Don Guillett SalesAid Software "JerryS" wrote in message ... I have a sheet that looks something like this: Date New Old 1/1/06 10 1/5/06 5 5 1/8/06 20 1/8/06 15 5 How do I get a total for New and old between specific dates? For example, dtotal New between 1/1/06 and 1/5/06? Thanks -- JerryS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals based on meeting multiple criteria
Hi Jerry
One way =SUMPRODUCT(--($A$2:$A$100=DATE(2006,1,1),--($A$2:$A$100<=DATE(2006,1,5),$B$2:$C:100) -- Regards Roger Govier "JerryS" wrote in message ... I have a sheet that looks something like this: Date New Old 1/1/06 10 1/5/06 5 5 1/8/06 20 1/8/06 15 5 How do I get a total for New and old between specific dates? For example, dtotal New between 1/1/06 and 1/5/06? Thanks -- JerryS |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals based on meeting multiple criteria
=SUMIF(A:A,"<=1/5/2006",B:B)-SUMIF(A:A,"<1/1/2006",B:B)
Vaya con Dios, Chuck, CABGx3 "JerryS" wrote in message ... I have a sheet that looks something like this: Date New Old 1/1/06 10 1/5/06 5 5 1/8/06 20 1/8/06 15 5 How do I get a total for New and old between specific dates? For example, dtotal New between 1/1/06 and 1/5/06? Thanks -- JerryS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting by multiple criteria | Excel Worksheet Functions | |||
COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions | |||
Using Sumproduct with multiple Criteria | Excel Worksheet Functions | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |