Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct for month and year
Hi,
I am trying use sumproduct to add totals for a month when the criteria or date column is in the date format mm/dd/yyyy. For example the month column could have the following dates 06/04/2006 06/17/2006 06/21/2006 07/12/2006 07/18/2006 08/16/2006 08/24/2006 08/31/2006 I need to get the totals for the month 06/2006, 07/2006, and 08/2006 Thanks for your help. -- Benjamin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct for month and year
=sumproduct(--text(a1:a100,"yyyymm")="200606"),b1:b100)
Adjust the range, but don't use the whole column. Benjamin wrote: Hi, I am trying use sumproduct to add totals for a month when the criteria or date column is in the date format mm/dd/yyyy. For example the month column could have the following dates 06/04/2006 06/17/2006 06/21/2006 07/12/2006 07/18/2006 08/16/2006 08/24/2006 08/31/2006 I need to get the totals for the month 06/2006, 07/2006, and 08/2006 Thanks for your help. -- Benjamin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct in a given year | Excel Worksheet Functions | |||
Vacation Time calculation... HELP! | Excel Discussion (Misc queries) | |||
Lookup returns wrong value | Excel Worksheet Functions | |||
holiday dates | Excel Worksheet Functions | |||
How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) |