| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average
Hi!
I have: A B 1 x 100 2 y 0 3 z 200 4 5 I would like average B1:B5 if A1:A5 < "" In this case: AVG=150 Thanks in advance. an |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average
Hi
From the result you are showing, you want to exclude 0 values, not nulls. The average function automatically excludes nulls. Try =AVERAGEIF(B1:B3,"<0") -- Regards Roger Govier "an" wrote in message ... Hi! I have: A B 1 x 100 2 y 0 3 z 200 4 5 I would like average B1:B5 if A1:A5 < "" In this case: AVG=150 Thanks in advance. an |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average
Ok, RG.
Perfect. Many thanks. an "Roger Govier" wrote: Hi From the result you are showing, you want to exclude 0 values, not nulls. The average function automatically excludes nulls. Try =AVERAGEIF(B1:B3,"<0") -- Regards Roger Govier "an" wrote in message ... Hi! I have: A B 1 x 100 2 y 0 3 z 200 4 5 I would like average B1:B5 if A1:A5 < "" In this case: AVG=150 Thanks in advance. an |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Hybrid Mode
