=IF(D100,COUNTif('Transaction Data'!$C:$C,$B10,'Transaction
Data'!O:O),"0"),0)

This formula won't work. I am getting a message, "too many arguments in the
function".

I need this formula to work when the total in the first worksheets is 0,
then to count # of transaction in the separate worksheet that are 0 (not all
transactions). In addition, I need to count the # of transactions 0 only for
a specific range determined by $B10 from the first worksheet.

Can you help?

Thank you. Natalia