| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement then Average
I have a column that has percentages in it; some have #'s great than zero
while others show a zero percentage. I would like my formula to say if the cell = 0% then don't include in average calculation. Is this possible? Thank you, Renee |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement then Average
Hi
=AVERAGE(IF(A1:A100,A1:A10,FALSE)) Extend the range to suit. It's an array so commit with Ctrl+Shift+Enter Mike "Renee" wrote: I have a column that has percentages in it; some have #'s great than zero while others show a zero percentage. I would like my formula to say if the cell = 0% then don't include in average calculation. Is this possible? Thank you, Renee |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement then Average
=AVERAGE(IF(B1:B100<0,B1:B100,"")) as an array formula (Control Shift
Enter) -- David Biddulph "Renee" wrote in message ... I have a column that has percentages in it; some have #'s great than zero while others show a zero percentage. I would like my formula to say if the cell = 0% then don't include in average calculation. Is this possible? Thank you, Renee |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement then Average
Great thanks, that works. But now I have the autofilter on so when I select
one name I want to show the Average for just that name and not the average for all the names. Is this possible? "David Biddulph" wrote: =AVERAGE(IF(B1:B100<0,B1:B100,"")) as an array formula (Control Shift Enter) -- David Biddulph "Renee" wrote in message ... I have a column that has percentages in it; some have #'s great than zero while others show a zero percentage. I would like my formula to say if the cell = 0% then don't include in average calculation. Is this possible? Thank you, Renee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for average with a "IF" statement | Excel Discussion (Misc queries) | |||
| Help with complex average/if statement | Excel Worksheet Functions | |||
| Average with more than one IF statement | Excel Worksheet Functions | |||
| Conditional Statement to Compute Average | Excel Worksheet Functions | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
Linear Mode
