I have a SUMPRODUCT formula to sum current, previous and next quarters from a long list of sales income over a 25 year period. The formula looks at the date in a specified cell (D2) to determine which quarter the month falls into and in the example below totals the income for the previous quarter (assumes Q1 = Jan, Feb, Mar, Q2 = Apr, May, Jun etc).
See sample file attached.
I have Dates in Column A, 31-Jan-2001, 28-Feb-2001, 31-March-2001 and so on for 25 years and sales totals in Column B.
To calculate the previous quarter my SUMPRODUCT formula is
This works perfectly...
However, I need to achieve the same thing using a SUMIFS formula but I can't seem to get this to work, it always resolves to zero!
Where am I going wrong?
Bookmarks