| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use complex criteria in SUMIF()
I would like a simple formula which will give the totals for a month from a
(large)list in another worksheet . |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use complex criteria in SUMIF()
=SUMPRODUCT(--TEXT(Sheet2!A2:A2000,"mmmyyyy")="May2006"),Sheet2! B2:B2000)
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "jjh64miles" wrote in message ... I would like a simple formula which will give the totals for a month from a (large)list in another worksheet . |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use complex criteria in SUMIF()
Thanks I tried this - but dates all diferent days, i.e 01/12/05, 25/12/05,
15/12/05 etc(@500 per month) and list formatted for report so not by date. jjh64miles "Bob Phillips" wrote: =SUMPRODUCT(--TEXT(Sheet2!A2:A2000,"mmmyyyy")="May2006"),Sheet2! B2:B2000) -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jjh64miles" wrote in message ... I would like a simple formula which will give the totals for a month from a (large)list in another worksheet . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use complex criteria in SUMIF()
But my example extracted the month from the date, so many per month, one or
none is irrelevant -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jjh64miles" wrote in message ... Thanks I tried this - but dates all diferent days, i.e 01/12/05, 25/12/05, 15/12/05 etc(@500 per month) and list formatted for report so not by date. jjh64miles "Bob Phillips" wrote: =SUMPRODUCT(--TEXT(Sheet2!A2:A2000,"mmmyyyy")="May2006"),Sheet2! B2:B2000) -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jjh64miles" wrote in message ... I would like a simple formula which will give the totals for a month from a (large)list in another worksheet . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Multiple SUMIF Criteria | Excel Worksheet Functions | |||
| SumIf formula with complex criteria | New Users to Excel | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Linear Mode
