G
Guest
Hi,
I have this formula that works between worksheets:
=IF(SUMIF('Transaction Data'!$C:$C,$B10,'Transaction
Data'!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),">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.
I have this formula that works between worksheets:
=IF(SUMIF('Transaction Data'!$C:$C,$B10,'Transaction
Data'!P
)<0.05*$H$1,0,SUMIF('Transaction Data'!$C:$C,$B10,'TransactionData'!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
),">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.