|
| 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
August 30th, 2005, 05:25 PM
|
|||
|
|||
Create AVGIF function
Does anyone know how to create an average if function similiar to a SUMIF
function? I'm not that familiar with VBE so I believe this is out of my league. Any advice would be helpful. Regards 
|
|
#2
August 30th, 2005, 05:34 PM
|
|||
|
|||
|
You can use a SUMIF() divided by a COUNTIF that uses the same criteria
"plindsay" wrote: Does anyone know how to create an average if function similiar to a SUMIF function? I'm not that familiar with VBE so I believe this is out of my league. Any advice would be helpful. Regards
|
|
#3
August 30th, 2005, 05:34 PM
|
|||
|
|||
|
How about SUMIF()/COUNTIF()
-- Gary's Student "plindsay" wrote: Does anyone know how to create an average if function similiar to a SUMIF function? I'm not that familiar with VBE so I believe this is out of my league. Any advice would be helpful. Regards
|
|
#4
August 30th, 2005, 05:40 PM
|
|||
|
|||
|
Assume you have numbers in A1:A10,
and certain cells marked as "X" within B1:B10 We could try in say, C1, array-entered (i.e press CTRL+SHIFT+ENTER): =AVERAGE(IF(B1:B10="X",A1:A10)) which will evaluate the average of only those numbers in col A corresponding to the "x" marked in col B -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "plindsay" wrote in message ... Does anyone know how to create an average if function similiar to a SUMIF function? I'm not that familiar with VBE so I believe this is out of my league. Any advice would be helpful. Regards
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
| Create a function wher last digit is always set | mcd_fan | Worksheet Functions | 4 | July 9th, 2005 04:07 AM |
| Automatically up date time in a cell | Mark | General Discussion | 5 | May 12th, 2005 12:26 AM |
| clock | Wildman | Worksheet Functions | 2 | April 26th, 2005 10:31 AM |
| Create a command button that runs the Filter By form function | Donna | Using Forms | 4 | February 21st, 2005 03:22 AM |
Linear Mode
