COUNTIF Function

N

Natalia

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(D10>0,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.
 
N

N Harkawat

=IF(D10>0,sumproduct(--('Transaction Data'!$C1:$C9999=$B10),--('Transaction
Data'!P1:p1000)),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top