I have the following formula set-up to calculate a certain cell range based
on the date range. I also would like to put in one criteria, but I can't
seem to get it to work.

Help?

=SUMIF(O2:O200,"=04/01/2005",R2:R200)-SUMIF(O2:O200,"04/07/05",R2:R200)

Example - If the date range falls between these dates and is coded "pp/nc".
How do I add in the other criteria???