from your question to bob
(O2:O200=04/01/2005) when used this way is a conditional function with a
"true" / "false" response. putting the -- in front of it converts it to
being a 1,0 response. any conditionally equation cna be used in this manner
(note i did have to convert ot the date number when i checked it this time
=sumproduct(--(O2:O200=38433),(R2:R200),--(O2:O20038449),--(code range =4)
would be a valid equation.
"bj" wrote:
one possibility would be to use Sumproduct as in
=sumproduct(--(O2:O200=04/01/2005),(R2:R200),--(O2:O20004/07/05),--(range
="pp/nc") )
You may have to use the seriallized dates, dates do strange things in my
computer.
"Maddie" wrote:
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???
|