Using Countif two criteria
You can use COUNTIF if you only have one condition. In this case try:
=SUMPRODUCT((B1:B100="F")*(ISNUMBER(C1:C100))
Hope this helps.
Pete
On Nov 19, 10:49 am, Mifty wrote:
Hi Everyone,
I would like to be able to count the number of females with a score in C.
so using Countif how do I say countif B = F and C equals a number?
I'd be grateful for any ideas how to do this.
Could I use Sumproduct as an alternative to countif?
Thanking you in advance
--
Mifty
|