View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ScottFisher2004 ScottFisher2004 is offline
external usenet poster
 
Posts: 6
Default How to only incld cells that meet set condition in an Excel calc?

I'm looking for instructions on how to create a calculation that only
includes cells that meet a specified condition in a subsequent calculation.
For example, visualize a sheet with three columns...account name, pricing
incentive offered to each account, and the sales result (sale / no sale).
Each account would have it's own row. I want to calculate the average
pricing incentive offered to only those accounts that resulted in a sale.