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
|