For COUNT, you can use a single formula, as it accepts multiple ranges, i.e.

=COUNT(A1:A5,C1:C5)

On Mon, 26 Sep 2005 11:01:04 -0700, "Debi"
wrote:

What would be the formula specifics when I want to use the count or countif
funtion with two criteria. Example:
Count A1:A5 and c1:c5
countif A1:A5 equals f and D1:D5 equals h
Countif A1:A5 equals f and count D1:D5