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