| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Product by Month formula
"Brian" wrote:
What if I want by month and year? That is, I need to separate January 2007 from January 2008. You could use TEXT, like this: =SUMPRODUCT((TEXT($A$2:$A$20,"mmmyy")="Jan07")*($B $2:$B$20="Wagon")) =SUMPRODUCT((TEXT($A$2:$A$20,"mmmyy")="Jan08")*($B $2:$B$20="Wagon")) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to get a Boolean formula to work month-to-month | Excel Discussion (Misc queries) | |||
| Sum product the right formula? | Excel Discussion (Misc queries) | |||
| Product formula help | Excel Worksheet Functions | |||
| product sum per month per customer | Excel Worksheet Functions | |||
| Sm Product a Calendar Month Range? | Excel Worksheet Functions | |||
Hybrid Mode
