Thread: Formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cooldistribution Cooldistribution is offline
external usenet poster
 
Posts: 2
Default Formula help

I am trying to program excel to return rows and values based on criteria and
need some help on which formula to use and how. I need a separate excel
document to add part numbers and qty whose sales are over a certain amount
for a given period of time. See below for example

Part# Description 1st Qtr Avg. 2nd Qtr Avg. 3rd Qtr Avg.
4th Qtr Avg
1 Float .67 .75
.38 1.45


I need the excel document to pull the part# description and qty if two
consecutive qtrs avg .67 and above and add it to a separate excel file.