Is there formula similar to SUMIF that will work for average

J

johnu

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
 
A

akphidelt

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.
 

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

Is there formula similar to SUMIF that will work for average? 2
I need to write a PRODUCT formula that mimics a SUMIF 3
Looking for function similar to Access "Group By" queries 4
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1
Is there a way to call an API in unmanaged DLL from C# application in a way that the name of the API 1
Understanding the Cell Microprocessor [VERY LONG] 12
FWT Newsletter - Weekly - November 1, 2004 0
FWT Newsletter - Weekly - October 4, 2004 2

Top