Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif OR function
Hi
I am using the following formula to calculate the number of males and females in my class lists. It works well. COUNTIF(D3:D28,"M") COUNTIF(D3:D28,"F") I want to count the total number of Males and Females, I am currently using a a sum function on the range but is it possible to use an OR expression inside a function? Basically what I was looking for was a version of what follows (that works!) COUNTIF(D3:D28,"M" or "F") so if there were 5 males and 7 females it would return the value 12. this is more for my own education than anything else. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
COUNTIF and then SUM in Same Function | Excel Worksheet Functions | |||
A COUNTIF function Challenge | Excel Worksheet Functions | |||
hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions |