Hi Pappas,

Try something like ...

=COUNTIF(range_central_division,"Booked")+COUNTIF( range_central_division,"Cancelled")
=COUNTIF(range_central_division,"Declined")

Wkr,

JP


"Pappas" . wrote in message
...
Need a COUNT of how many loans were either Booked OR Cancelled within the
Central Division. Alternately - need a COUNT of how many loans were
Declined in the Central Division.

I have tried this, but now out of options - Help!

=COUNTIF(AND($F$F1500, "Booked"OR"Cancelled", $B$2:$B$1500, "Central")
--
Pappas