Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there formula similar to SUMIF that will work for average
Is there a function or formula similar to SUMIF that will work for average,
median, & mode? I have an array of numbers with corresponding values similar to the following Nbhd Size 3401 .23 3401 .25 3401 .28 3402 .20 3402 .21 3402 .29 The difficulty is there are hundreds of neighborhoods and thousands of size values in the array. There is a serious time crunch and the task is too labor intensive to complete in the time allotted. Does anyone have any suggestions? Thanks, JohnU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there formula similar to SUMIF that will work for average
You can combine sumif with countif. For example, using your data assuming it
started in cell A2. =Sumif(A2:A7,"3401",B2:B7)/Countif(A2:A7,"3401") Of course you would change 3401 to a cell so that you can change the criteria you are looking for. "johnu" wrote: Is there a function or formula similar to SUMIF that will work for average, median, & mode? I have an array of numbers with corresponding values similar to the following Nbhd Size 3401 .23 3401 .25 3401 .28 3402 .20 3402 .21 3402 .29 The difficulty is there are hundreds of neighborhoods and thousands of size values in the array. There is a serious time crunch and the task is too labor intensive to complete in the time allotted. Does anyone have any suggestions? Thanks, JohnU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there formula similar to SUMIF that will work for average
See your other post
-- Biff Microsoft Excel MVP "johnu" wrote in message ... Is there a function or formula similar to SUMIF that will work for average, median, & mode? I have an array of numbers with corresponding values similar to the following Nbhd Size 3401 .23 3401 .25 3401 .28 3402 .20 3402 .21 3402 .29 The difficulty is there are hundreds of neighborhoods and thousands of size values in the array. There is a serious time crunch and the task is too labor intensive to complete in the time allotted. Does anyone have any suggestions? Thanks, JohnU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there formula similar to SUMIF that will work for average? | Excel Worksheet Functions | |||
Help 2nd request (sumif formula of similar 17-04-08) | Excel Discussion (Misc queries) | |||
sumif formula or similar | Excel Discussion (Misc queries) | |||
A formula maxif, similar with sumif or countif | Excel Worksheet Functions | |||
Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) |