You could use:
=SUM(COUNTIF(D3:D28,{"M","F"}))
or just
=COUNTIF(D3:D28,"M") + COUNTIF(D3:D28,"F")
(in one cell)
nospam wrote:
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
--
Dave Peterson
|