#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default COUNT function

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default COUNT function

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count function ??? [email protected] Excel Worksheet Functions 2 July 14th 09 04:48 PM
Count function MarekZ Excel Worksheet Functions 5 July 23rd 07 11:59 PM
Count function L.T. Excel Discussion (Misc queries) 4 January 20th 07 03:40 AM
i need help with the "count" function kippercat Excel Worksheet Functions 1 March 9th 05 09:58 AM
count function ChrisC Excel Worksheet Functions 5 November 9th 04 01:40 AM


All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"