S
scrabtree
How can I re-write the code below so that it finds the
data for F14:F1403 that is between 100000 and 200000?
SUM(($D$14:$D$1403=$B$1)*(F14:F1403<200000)*
($C$14:$C$1403=$B$6)))+(SUM(($D$14:$D$1403=$B$1)*
(F14:F1403>199999)*($C$14:$C$1403=$B$6))
data for F14:F1403 that is between 100000 and 200000?
SUM(($D$14:$D$1403=$B$1)*(F14:F1403<200000)*
($C$14:$C$1403=$B$6)))+(SUM(($D$14:$D$1403=$B$1)*
(F14:F1403>199999)*($C$14:$C$1403=$B$6))