| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
average range function
Hi all
I am trying to work out the average value of Column A1:A500. What I am needing is a formula that will exclude 0 from the calculations to give a true average. Probably an easy one, but cannot seem to locate the correct formula. Cheers Patrick |
|
#2
|
|||
|
|||
|
Hi Patrick,
you could use the DAverage formula to only sum values greater than 0 EXAMPLE |-----------| values 0 values 0 0 0 0 1 1 1 1 =DAVERAGE(A3:A11,"values",A1:A2) |---------| COPY (from values) THE ABOVE AN EXCEL SHEET AND SEE IT WORK! Regards, Zakir Ulla Patrick White said the following on 30/06/2005 1:59 PM: Hi all I am trying to work out the average value of Column A1:A500. What I am needing is a formula that will exclude 0 from the calculations to give a true average. Probably an easy one, but cannot seem to locate the correct formula. Cheers Patrick |
|
#3
|
|||
|
|||
|
Hi Kakir
It is coming up with #DIV/0! error. Regards Patrick "Zakir Ulla" wrote in message ... Hi Patrick, you could use the DAverage formula to only sum values greater than 0 EXAMPLE |-----------| values 0 values 0 0 0 0 1 1 1 1 =DAVERAGE(A3:A11,"values",A1:A2) |---------| COPY (from values) THE ABOVE AN EXCEL SHEET AND SEE IT WORK! Regards, Zakir Ulla Patrick White said the following on 30/06/2005 1:59 PM: Hi all I am trying to work out the average value of Column A1:A500. What I am needing is a formula that will exclude 0 from the calculations to give a true average. Probably an easy one, but cannot seem to locate the correct formula. Cheers Patrick |
|
#4
|
|||
|
|||
|
Hi Patrick,
Enclosed please find a working example of the sheet. The only error that i think is in CELL A2, where you need to type "0" Test it and reply back Regards, Zakir Ulla Patrick White said the following on 30/06/2005 3:55 PM: Hi Kakir It is coming up with #DIV/0! error. Regards Patrick "Zakir Ulla" wrote in message ... Hi Patrick, you could use the DAverage formula to only sum values greater than 0 EXAMPLE |-----------| values 0 values 0 0 0 0 1 1 1 1 =DAVERAGE(A3:A11,"values",A1:A2) |---------| COPY (from values) THE ABOVE AN EXCEL SHEET AND SEE IT WORK! Regards, Zakir Ulla Patrick White said the following on 30/06/2005 1:59 PM: Hi all I am trying to work out the average value of Column A1:A500. What I am needing is a formula that will exclude 0 from the calculations to give a true average. Probably an easy one, but cannot seem to locate the correct formula. Cheers Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| what's the closest think to an "average if" function? | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Using Average function when number is zero | Excel Worksheet Functions | |||
Linear Mode
