count if function with if statements
=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
|