View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mellybean Mellybean is offline
external usenet poster
 
Posts: 3
Default Adding the value of cells than 4.5

I am working with a sheet containing numbers in cells between 1-6, I only
need the numbers 4.5 or greater, and average those numbers. what is the
formula for it to determine say cells A1:A30 only the ones 4.5 + the average