What do the -- represent???? Can I still use the quotes with a number.
Example - Instead of "pp/nc" I want it to bring back those that have a
number 4 in the column??
"Bob Phillips" wrote:
=SUMPRODUCT(--(O2:O200=--"2005-04-01"),--(O2:O200<"2005-04-07"),--(P2:P200=
"pp/nc"),R2:R200)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Maddie" wrote in message
...
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???
|