Variable Functions

  • Thread starter Thread starter Sam Bench
  • Start date Start date
S

Sam Bench

I have a spreadsheet that contains a column of numbers. Sometimes I want to
know the max of the numbers in the column, sometimes the min, sometimes the
average, etc.

Is there a way for me to type the word MAX or MIN or AVERAGE or . . . into a
cell and have the appropriate value appear right below the word I typed?
That would mean that the function would have to be set by the words I type
in the cell above where the function is located.

Any input would be appreciated. Thanks.
 
Why not just assign 6 cells to provide this info for you.

Enter MAX, MIN, and AVG in 3 cells, and under each, enter the appropriate
formula.
 
Sam

You can select a range then right-click on the Status Bar you can get all those
options to pick from.

Won't go into the cell, but you will see what the value is.

If you want a formula try the dropdown on the AutoSum button . There are
options there also for Max, Min, Average or.........

Select a cell and your desired function then select the column and ENTER.


Gord Dibben MS Excel MVP
 
Back
Top