Thread: average if
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
 
Posts: 207
Default average if

Hi All,

I am trying to take out the average of all the values in column B which have
"Start of Day" in Coumn A. I tried =AVERAGE(IF(A:A="Start of Day",B:B)) but
doesnt work...need help.

Thanks
Gaurav