View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HARSH BAHAL HARSH BAHAL is offline
external usenet poster
 
Posts: 14
Default Conditional averages

I have in a row (adjacent coloumns)months & quarters (Jan, Feb, March,
quarter 1...upto Quarter 4 and then year total). I want to calculate the
annual average ignoring the quarter figures and the blank cells also. Pl help