ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   COUNT function (https://www.excelbanter.com/excel-discussion-misc-queries/253287-count-function.html)

Darby

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

מיכאל (מיקי) אבידן

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



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com