Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
performing function on selected rows
Hi,
I've assumed that the date column is text and not a formatted date =MAX(IF(A2:A11="January",B2:B11)) =MIN(IF(A2:A11="January",B2:B11)) =AVERAGE(IF(A2:A11="January",B2:B11)) These are array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array Mike "drose" wrote: I would like to know if there is a way or function that would allow me to look at a table and take the mean, min, max and range of supply for January. month supply January 5 Feburary 4 January 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
performing function on selected rows | Excel Programming | |||
performing function on selected rows | Excel Programming | |||
performing different calculatons on whether yes or no is selected | Excel Worksheet Functions | |||
Performing Action on a Range of Rows | Excel Discussion (Misc queries) | |||
Function to return # of column with min value in selected rows | Excel Worksheet Functions |