Thank you very much this saves me a great deal of timew ands reduce
redundancy. I greatly appreciate your assistance!!

"Debi" wrote:

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)