View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mifty Mifty is offline
external usenet poster
 
Posts: 99
Default Using Countif two criteria

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