=SUMPRODUCT((A1:A5="f")*(D1:D5=0)*(D1:D5<""))

Regards

Trevor


"Debi" wrote in message
...
My previous question perhaps was not worded correctly.
What is the specific text for using the count of countif funtions with two
criteria with both criteria to be met for the cell to be counted example

Countif A1:A5 equals f AND D1:D5 equals 0

Count A1:A5 AND D1:D5 (sum should only count one cell within the same
row)