View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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