View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default How do I use a countif function according to two other countif fu.

=sumproduct(--(rng1="value1"),--(rng2="value2"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Kirsty" wrote in message
...
I have two countif formulas and I want to count the number of cells that
agree with both of these. Can anyone help please? I've searched the online
help but can't find anything.
Thanks