If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"AverageIF" alternative
Since there isn't an averageif, what is the best way to average a particular
set of numbers? Thanks. |
#2
|
|||
|
|||
sumif()divided by countif()
-- Greetings from New Zealand Bill K "Flutie99" wrote in message ... Since there isn't an averageif, what is the best way to average a particular set of numbers? Thanks. |
#3
|
|||
|
|||
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=AVERAGE(IF(condition,rng)) where rng is your range of cells. In article , "Flutie99" wrote: Since there isn't an averageif, what is the best way to average a particular set of numbers? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dlookup Alternative for Performance Improvement? | G | Running & Setting Up Queries | 2 | March 17th, 2005 09:34 PM |
Create an AVERAGEIF function. | as | Worksheet Functions | 2 | March 2nd, 2005 01:27 PM |
Mail merge Deployment issue with ASP.net and alternative ?? | sanjeeev | Mailmerge | 0 | January 12th, 2005 10:46 AM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |