View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
drd drd is offline
external usenet poster
 
Posts: 2
Default need to average based on criteria

In column B there are letters "A,AC,P,PB,S".
In column U there are numbers.
need formula that searches column B for the letters "A" and "AC" then goes
to column U and averages those numbers that meet the criteria.
I have Excel 2003
Thx