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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Need help with a formula 3
Finding most recently entered number within a column 3
Finding the proper style field and the numbered paragraph value within the style 0
Section and Page numbering 0
Mail Merge Directory Conditional Page Break 0
Help calculating scaled commissions please 5
Formula for calculating target hours against actual hours 12

Top