Formula format for Count or Countif funtion with two criterias

[Guest]

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 D15 equals h
Countif A1:A5 equals f and count D15

 

[Guest]

=COUNT(A1:A5)+COUNT(C1:C5)
=SUMPRODUCT(--(A1:A5="f"),--(D15="h"))
=SUMPRODUCT(--(A1:A5="f"),--(D15<>""))

 

[Myrna Larson]

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

=COUNT(A1:A5,C1:C5)