COUNTIF

  • Thread starter Thread starter Pappas
  • Start date Start date
P

Pappas

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")
 
Hi Pappas,

Try something like ...

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

Wkr,

JP
 
Hi

Try

=SUMPRODUCT(((F1:F1500="Booked")+(F1:F1500="Cancelled"))*(B1:B1500="central"))

Add absolute references as needed, note your sample formula is missing the
row for the first F and the two ranges are not equal - the second starts on
row 2 - they need to be the same length.
 
You can use Don's version but you must make the changes I mentioned:

=SUMPRODUCT((B1:B13="central")*(F1:F13={"Cancelled","Booked"}))
 
All suggestions worked beautifully; however, it was only part of my formula .
.. . . this is what I have come up with so far . . . . now I need help with
just the last part underlined.

=SUMPRODUCT((($F$2:$F$1500={" Booked"," Cancelled"})*($B$2:$B$1500=" North
Mississippi")*(($E$2:$E$1500>33%)*(F21500<=35.99%))))
______________________________________

I need to add one additional . . . if between 33% and 35.99% . . . . but
the result is wrong - so I am know I am not doing something right.

Thanks!!!
Pappas
 
Jp Ronse, Don Guillett, & Shane . . . . Thanks for the initial HELP - It
worked Beautifully!!!!! However on my reply - Nevermind - I figured it
out - Thanks again!!!!

This is what I came up with and it worked great!!!! Thank you!!!

=SUMPRODUCT((($F$2:$F$1500={" Booked"," Cancelled"})*($B$2:$B$1500=" North
Mississippi")*(($E$2:$E$1500>30%)*($E$2:$E$1500<=32.99%))))
 
Back
Top