Try this:

=SUMPRODUCT(--(FAWAD!$O$2:$O$4000=$E$2),--(FAWAD!$L$2:$L$4000=DATEVALUE("4/25/2008")),--(FAWAD!$L$2:$L$4000<=DATEVALUE("5/1/2008")))

HTH,
Paul

--

"Brooke" wrote in message
...
I have the following formula -

=SUM(IF(FAWAD!$O$2:$O$4000=$E$2,IF(FAWAD!$L$2:$L$4 000=DATEVALUE("4/25/2008"),1,0)))-SUM(IF(FAWAD!$O$2:$O$4000=$E$2,IF(FAWAD!$L$2:$L$40 00DATEVALUE("5/1/2008"),1,0)))

I want to include another datevalue range and I'm not sure how to
incorporate it into this formula. Like if Cells O = Yes (E2) and Cells L
=
Certain Date Range and then I want to add another If Cells P = another
certain date range. It will then count total number of accounts.

Criterial in the end being

1. Has to equal Yes
2. Contract date needs to equal specific Date Range
3. Visited date needs to equal specific Date Range

Then it counts total number of accounts with the above criteria.

Is it possible to add to date ranges to the formula??

Thanks
Brooke