I need help to average a set of numbers in a column based on the data in
another column. Example:
c35=45%, c36=55%, c37=65%, c38=75%
d35=2.2, d36=2.3, d37=2.4, d38=2.5
I want to average the numbers in d column only if corresponding number in c
column is = or 50% and = or<70% ignoring zero or blank cells.
Appreciate any help!