Frequecy with logical value

  • Thread starter Thread starter ksnapp
  • Start date Start date
K

ksnapp

for example lets say in row 1 i have a long list of day numbers.

in row 3 i have a bunch of values

below all of that i have my table with is the Bins array

i need the frequency to only evaluate the values in row 3 if the cel
in row 1 is = 1.

i tried this and it didn't work


{=frequency(if(1:1=1,3:3,A16:20))}

any ideas on how I can accomplish thi
 
Hi
one way to do this would be using a workaround with SUMPRODUCT. e.g.
=SUMPRODUCT(--($A$1:$X$1=1),-($A$3:$X$3<=A16),$A$3:$X$3)
 
Back
Top