| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help w/IF formula, I'm not quite doing it right
I have excel 2003:
I'm averaging a column of figures and I want to ignore any cells that have a zero or that have a #REF! (0 only means that report hasn't been turned in yet, and #ref! means the sheets that this worksheet will link to haven't been created yet - it's a YTD sheet.) Thanks, Meenie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help w/IF formula, I'm not quite doing it right
=AVERAGE(IF(ISERR(A1:A7),"",IF(A1:A7=0,"",A1:A7))) as an array formula
(Control Shift Enter) -- David Biddulph "Meenie" wrote in message ... I have excel 2003: I'm averaging a column of figures and I want to ignore any cells that have a zero or that have a #REF! (0 only means that report hasn't been turned in yet, and #ref! means the sheets that this worksheet will link to haven't been created yet - it's a YTD sheet.) Thanks, Meenie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help w/IF formula, I'm not quite doing it right
Perfect! Thanks so much :)
"David Biddulph" wrote: =AVERAGE(IF(ISERR(A1:A7),"",IF(A1:A7=0,"",A1:A7))) as an array formula (Control Shift Enter) -- David Biddulph "Meenie" wrote in message ... I have excel 2003: I'm averaging a column of figures and I want to ignore any cells that have a zero or that have a #REF! (0 only means that report hasn't been turned in yet, and #ref! means the sheets that this worksheet will link to haven't been created yet - it's a YTD sheet.) Thanks, Meenie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
