View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sue
 
Posts: n/a
Default Sum/average numbers in column A dependant on value in column B

I would like to sum/average numbers in column A, only if for that row, the
value in column B is a certain value.
e.g. Average column A if value in column B is 1. Then again, average of
column A if value in column B is 2 etc.
A B
4 1
5 2
8 1
7 2
Thanks