Hi,

I have this formula that works between worksheets:
=IF(SUMIF('Transaction Data'!$C:$C,$B10,'Transaction
Data'!P:P)<0.05*$H$1,0,SUMIF('Transaction Data'!$C:$C,$B10,'Transaction
Data'!N:N))

Can I make it to work with COUNTIF function where I want to look for a # of
transactions 0? but only when 1) D10 is greater than 0, then 2) for those
values in the second worksheet that much the value $B10 from the first
worksheet, 3) I need # of transactions in column N 0, or otherwise if no
match return 0.

This is what I am having trouble with:

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

Any idea how I should change the above formula to work with COUNTIF? Again,
it works with SUMIF.

Thank you for your help.

--
Natalia

=IF(D100,sumproduct(--('Transaction Data'!$C1:$C9999=$B10),--('Transaction
Data'!P1:P1000)),0)

"Natalia" wrote in message
...
Hi,

I have this formula that works between worksheets:
=IF(SUMIF('Transaction Data'!$C:$C,$B10,'Transaction
Data'!P:P)<0.05*$H$1,0,SUMIF('Transaction Data'!$C:$C,$B10,'Transaction
Data'!N:N))

Can I make it to work with COUNTIF function where I want to look for a #
of
transactions 0? but only when 1) D10 is greater than 0, then 2) for those
values in the second worksheet that much the value $B10 from the first
worksheet, 3) I need # of transactions in column N 0, or otherwise if no
match return 0.

This is what I am having trouble with:

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

Any idea how I should change the above formula to work with COUNTIF?
Again,
it works with SUMIF.

Thank you for your help.

--
Natalia