Hoopsah
11-02-2010, 04:47 AM
Hi
just wondering if anyone knows a nicer formula for retrieving the month from a cell.
I am trying to do a sumproduct where there are 3 columns,
Column 1 - Date (01/01/99)
Column 2 - Region (Ness, Don, Clyde...)
Column 3 - Complaint (Adoption, Capacity...)
the problem I have is that the date is stored as 01/01/99 and I want to run the formula to extract only the ones that fall under a specific month.
I created a column with the formula MONTH() but is there a way I can incorporate it into the SUMPRODUCT formula?
Thanks for any help
just wondering if anyone knows a nicer formula for retrieving the month from a cell.
I am trying to do a sumproduct where there are 3 columns,
Column 1 - Date (01/01/99)
Column 2 - Region (Ness, Don, Clyde...)
Column 3 - Complaint (Adoption, Capacity...)
the problem I have is that the date is stored as 01/01/99 and I want to run the formula to extract only the ones that fall under a specific month.
I created a column with the formula MONTH() but is there a way I can incorporate it into the SUMPRODUCT formula?
Thanks for any help