Jeff

I would use sumproduct for this

For the eg of "Number of 'Satisfactory' at 'Carson' Location "
Assuming Location = colunm A, and rating = colunm F, and first row of data =
1, and last row of data = 450, Try:

=SUMPRODUCT((A1:A450="Carson")*(F1:F450="Satisfact ory"))

Hope it helps!


"Jeff" wrote:

It's been a while since I've used Excel and I am struggling to do a countif
with multiple criteria. Perhaps it is the wrong function?

On the a spreadsheet, I would like to count the number of times a specific
LOCATION receives a specific RATING.

Here is a sample of spreadsheet

Location From To Review Date Eval Type
Rating

Silverton 12-Sep-06 9/7/2007 07-SEP-07 Increment Very Good
Silverton 9/12/2006 1/12/2007 12-JAN-07 Probationa Very Good
College H 8/28/2007 1/28/2007 28-DEC-07 Probationa Satisfactory
Riverview 9/12/2006 9/8/2007 08-SEP-07 Increment Very Good
Riverview 9/12/2006 1/12/2007 12-JAN-07 Probationa Satisfactory
Hughes 11/1/2007 01-NOV-07 BI-Annual
Satisfactory
Hughes 11/1/2006 01-NOV-06 BI-Annual No
Rating
Jones 11/1/2004 11/1/2006 01-NOV-06 BI-Annual Satisfactory
Carson 11/1/2004 11/1/2006 01-NOV-06 BI-Annual Satisfactory
Withrow 11/1/2004 11/1/2006 01-NOV-06 BI-Annual Satisfactory

A result would be: Number of "Very Good" at "Silverton"

or

Number of "Satisfactory" at "Carson"

Its a big spread sheet, 450 records (rows)

thanks, this should help me get my raise!

--
Jeff