| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
