Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimum Value | Excel Worksheet Functions | |||
Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
minimum | Excel Worksheet Functions | |||
Rounding up results to meet minimum order quantities. | Excel Worksheet Functions |