Hi,
I have a list of prices, their frequencies and the medium price for the transactions. I need to write a formula that will count number of transactions that are +-15% of a median price (I already separately determined median price).
BESP Analysis contains all the individual transactions from which need to pull the data
Pivot Table contains the calculations for the Medium Price and the respective frequencies
Here's what I got so far but it keeps returning a zero. Please HELP. Thank you
=COUNTIFS('BESP Analysis 2012 2013'!J2:J5894,'BESP Analysis 2012 2013'!J2:J5894*1.15<='Pivot Table'!K4)*('BESP Analysis 2012 2013'!J2:J5894*0.75>='Pivot Table'!K4)
I have a list of prices, their frequencies and the medium price for the transactions. I need to write a formula that will count number of transactions that are +-15% of a median price (I already separately determined median price).
BESP Analysis contains all the individual transactions from which need to pull the data
Pivot Table contains the calculations for the Medium Price and the respective frequencies
Here's what I got so far but it keeps returning a zero. Please HELP. Thank you
=COUNTIFS('BESP Analysis 2012 2013'!J2:J5894,'BESP Analysis 2012 2013'!J2:J5894*1.15<='Pivot Table'!K4)*('BESP Analysis 2012 2013'!J2:J5894*0.75>='Pivot Table'!K4)
