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