LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Minimum Value Alex Excel Worksheet Functions 2 August 1st 07 03:44 PM
Conditional Sum Argument results do not equal cell results Excel Randy R Mullins Excel Worksheet Functions 3 August 9th 06 07:16 PM
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough Excel Worksheet Functions 8 July 15th 06 09:39 PM
minimum ridash Excel Worksheet Functions 4 June 23rd 06 03:00 PM
Rounding up results to meet minimum order quantities. Vin C. Excel Worksheet Functions 2 February 7th 06 06:38 PM


All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"