How do i calculate a difference formula in a column of numbers in.

J

jennymomof2

I am trying to figure a formula that would find the difference between the
highest and lowest number in a column in Excel 2000. Each week another
number is added. Any help would be greatly appreciated.
 
C

CarlosAntenna

If column A has your numbers:

=MAX(A:A)-MIN(A:A)

You can still add rows to the end of the list because you are referencing
the entire column.
 
Top