| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT breakdown by date
I'm currently using the formula below to breake it down by month but I also
need to have it breakdown those months by year. SUMPRODUCT(--(MONTH(Sheet!A1:A10)=1),--(Sheet!B1:B10=Sheet1!C1:C10),Sheet1B1:B10) This formula compares two columns and if those columns have the same data for the same month then it returns the sum of the data. The only problem is is does not distingush between year, which I need it to do so. Any help is appreciated. 1-JAN-05 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| Using sumproduct to count number by date | Excel Worksheet Functions | |||
| Date Math Problem | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Threaded Mode
