Hi, there, this question is kind of a follow up to the question linked below
which is in regard to summing values in a named range based upon date. I have
effectively 3 columns of data that interest me that are named as ranges:
Item_Name, Sale_Date and Sale_Amount. I am trying to create a spreadsheet
that is broken down by quarter so I am hoping for something that is basically

=SUMIF(Data_Range,(Item_Name=A$1 AND (1/31/08 -30 days)<Sale_Date<(1/31/08+2
months)),Sale_Amount)

I know that I can not write the formula above and that what I need is some
form of array but I am so behind on my excel skills that I have no idea how
to write the correct formula.

Any help would be really appreciated!


http://www.microsoft.com/office/comm...6-20ce5ca555ca