View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katie Katie is offline
external usenet poster
 
Posts: 130
Default I need to total col, but pick up number in other col. if not 0

I have two columns of figures i.e. Col. G has figures in each cell and have
totalled them and averaged them. In Col. F most of the cells have 0, but if
a cell is populated with a figure other than 0, then I need to use that
figure instead of the figure in Row G.