View Single Post
  #1   Report Post  
BAM718
 
Posts: n/a
Default I need to find the Average from Column A - but Reference Column B

Column A has a Range of Dollar Values ($0 - $100,000). Column B has a Range
of numbers from 0 to 100.

I want to return an average of the Dollar Values in column A but only using
the Dollar Values that have a corresponding number in column B between the
range of 0 to 10.