COUNT function

's Computer Specifications

I have a large spreadsheet and I need to figure out how to count items that
meet a certain criteria only if another criteria is met within another column
(for example: for all employees that are a grade 13, count how many of those
employees received a 3 rating)

Thanks for any help!!!
--
Darby

's Computer Specifications

Try the proposed formula:
http://img193.imageshack.us/img193/3857/nonamedb.png
Micky

"Darby" wrote:

> I have a large spreadsheet and I need to figure out how to count items that
> meet a certain criteria only if another criteria is met within another column
> (for example: for all employees that are a grade 13, count how many of those
> employees received a 3 rating)
>
> Thanks for any help!!!
> --
> Darby

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: COUNT or IF Function	Douglas J. Steele	Microsoft Access	1	17th Aug 2009 08:17 PM
Can't use COUNT function to count.csv rows?	Simon	Microsoft Excel Programming	1	11th Jul 2008 04:59 PM
enter a count function to count records?	Kimberly	Microsoft Access Queries	11	14th May 2008 07:39 AM
count function	=?Utf-8?B?TWFybHk=?=	Microsoft Access Queries	5	20th Jul 2007 02:20 PM
I'm trying to use the function COUNT entered as =COUNT(C5:C22,">0.	=?Utf-8?B?RXJpYyBBLg==?=	Microsoft Excel Worksheet Functions	6	29th Sep 2004 10:02 PM