You are here:
- Home
- Computing/Technology
- Microsoft Software
- Excel
- excell count function
Excel/excell count function
Advertisement
Question
I am trying to count how many times a "perm" staff member appears in a column but is either a "WM" (White Male) or "BEMM" (Black,Ethnic Minority Male)etc.
So I have a list with people names in Column A and column B has either "Perm" or "Interim" and Column C has either "WM" or "WF" or "BEMM" or "BEMF".
I have used COUNTIF to count the number of times each criteria appears in each column, but now I want to count how many Perm White Males, Perm White Females, etc.
COUNTIF doesn't seem to let me do this.
Is there another formula I need to use or have I inputted the formula wrong.
Please help. Many thanks.
Answer
Glyn,
Sorry I clicked the wrong button.
To do this you need to use an array function. Chip Pearson has a great tutorial on array functions on his site http://www.cpearson.com/excel/ArrayFormulas.aspx. Your formula will end up looking something like: {=SUM((B1:B200="Perm")*(C1:C200="WM"))}. Look over Chip's site and let me know if you have any specific questions.
Best regards,
Chad Welch
Related Articles
- Excel COUNT Function - Excel 2007 COUNT Function
- Excel SUM Function - Using the Excel SUM Function - Sum Function
- TRANSPOSE - Excel 2007 TRANSPOSE - Excel TRANSPOSE Function
- Excel IF Function - How to Create an Excel IF Function - Creating an Excel IF Function
- Excel COUNT - Excel COUNT Function - Using Excel COUNT Function
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Chad Welch
Expertise
I have a lot of experience with VBA; Sub procedures, functions etc. I am also very familiar with array formulas.
Experience
I've worked with Excel for several years. I've been answering questions on various groups and lists for a while.
Organizations
Brainbench MVP for MS Excel.
©2009 About.com, a part of The New York Times Company. All rights reserved.