Thread: COUNTIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pappas Pappas is offline
external usenet poster
 
Posts: 3
Default COUNTIF

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