View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
airgrz airgrz is offline
external usenet poster
 
Posts: 1
Default Subtract Min() from MAX()

I am trying to Subtract the MIN of a group from the MAX of a group!

How do I only use 0 numbers in the group!

Example:

1 $500
2 $300
3 $0 or blank
4 $50

I need $50 - $500 = $450
Not $0 - $500 = $500

Thank you in advance for your help!