You need to read in help how countif works
countif(range,criteria)
=IF(D100,SUMPRODUCT(--('Transaction Data'!$C1:$C1000=B10),--('Transaction
Data'!$O1:$O10000)),0)
will work, note that you cannot use the full range as in C:C but the above
will count entries where C1:C1000 equals B10 and O1:O1000 0
--
Regards,
Peo Sjoblom
"Natalia" wrote in message
...
=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
|