Thread: Minimum results
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jd jd is offline
external usenet poster
 
Posts: 91
Default Minimum results

Column A has some numbers in it, Column B has some numbers in it, and Column
C=A*B respectivily. At the bottom of column C is the Min, Max ,and Average
functions of column C i.e C31 =Min(C1:C30). Not all rows in A and B have
data but all cells in C have the formula. I don't have a problem with getting
the Average or Maximum of column C just the Minimum because it seems to think
the blank cells in column C are the minumums therefore my minimum cell (C31)
is blank even though the formula for cell C31 is there. Also I do not want
to have to go into each cell of column C and remove the formula because A & B
do not have data. Please help. Thanks

JD