Ok,

You stated I2 to L500.
Assuming that was supposed to be L2 to L500 and also assuming you mean
instead of column F, then:

=SUMPRODUCT(--(MONTH('2008'!A2:A500)=1),--(YEAR('2008'!A2:A500)=2008),--('2008'!D2:D500="Quotation
Award"),--('2008'!E2:E500="Construction"),('2008'!L2:L500))

Now, if you mean L2 to L500 added to F2 to F500, then:

=SUMPRODUCT(--(MONTH('[2008.xls]2008'!A2:A500)=MONTH(A1)),--(YEAR('[2008.xls]2008'!A2:A500)=YEAR(A1)),--('[2008.xls]2008'!D2:D500=A2),--('[2008.xls]2008'!E2:E500=A3),('[2008.xls]2008'!F2:F500)+('[2008.xls]2008'!I2:I500))


If you DID mean the sume of I2 to L500 and adding to F2 to F500, then maybe
this:

=SUMPRODUCT(--(MONTH('[2008.xls]2008'!A2:A500)=MONTH(A1)),--(YEAR('[2008.xls]2008'!A2:A500)=YEAR(A1)),--('[2008.xls]2008'!D2:D500="Quotation
Award"),--('[2008.xls]2008'!E2:E500="Construction"),('[2008.xls]2008'!F2:F500)+(SUM('[2008.xls]2008'!I2:L500)))


HTH,
Paul




--

"jcorle" wrote in message
...
Thanks again...

What if I wanted to add the cost amounts from columns I2 to L500 meeting
the
same standards as before?

Jen

"PCLIVE" wrote:

You're welcome.

You might also consider having the date you want to match the month and
year
to in a cell. Example - Let's say you put a date in cell A1 of the
current
sheet. That date should include the month and year that you want to pull
data for. (1/15/2008 the day (15) is not important as long as it is
valid.
Now you can change your formula to reference that cell when matching the
month and year. This will allow you to change just the date in that
cell.

Additionally, let's say the other criteria are also predefined in cells.
Date = A1
"Quotiation Award" = A2
"Construction" = A3

So now the formula might be:
=SUMPRODUCT(--(MONTH([2008.xls]Sheet1!A2:A500)=MONTH(A1)),--(YEAR([2008.xls]Sheet1!A2:A500)=YEAR(A1)),--([2008.xls]Sheet1!D2:D500=A2),--([2008.xls]Sheet1!E2:E500=A3),([2008.xls]Sheet1!F2:F500))

Regards,
Paul




--

"jcorle" wrote in message
...
THANK YOU THANK YOU! You are WONDERFUL! That formula is perfect!

"PCLIVE" wrote:

Maybe something like this:

=SUMPRODUCT(--(MONTH('2008'!A2:A500)=1),--(YEAR('2008'!A2:A500)=2008),--('2008'!D2:D500="Quotation
Award"),--('2008'!E2:E500="Construction"),('2008'!F2:F500))

HTH,
Paul

--

"jcorle" wrote in message
...
I have tried and tried to get this to work. I am trying to do this
all
in
one
formula and I think it's outsmarted me... maybe it outsmarted me
from
the
beginning, but I always thought I was pretty good at this.

Anyway, I am tring take the following information from one worksheet
and
put
it into another... Ultimately, I want to get How many Quoation
Awards
were
made for Construction in the month of January...
Column A: Date approved
Column D: Type (Quoation Award)
Column E: Code (Type of Quotation made)
Column F: Number (1 if quote, 0 if not)

=COUNT(IF('2008'!A2:A500,"=1/1/2008")-COUNTIF('2008'!A2:A500,"1/31/2008")-('[2008]2008'!D2:D500="Quotation
Award")*('[2008]2008'!E2:E500="Construction"),('[2008]2008'!F2:F500))

I also tried it this way, but this doesn't include the January bit.:
=COUNT(IF(('[2008]2008'!D2:D500="Quotation
Award")*('[2008]2008'!E2:E500="Construction"),('[2008]2008'!F2:F500)))

Also, everytime I update a cell, it wants me to update the data from
the
spreadsheet... HUH?! I'm ready to scrap the whole thing and start
over.

Any help would be GREATLY appreciated - I also am going to do it for
several
other items, but once I get it, I can change it to fit!

Jennifer L. Corle
City of South Bend
Engineering