assuming your data (one column range) are in A1:A100
and there are some 0 (blank / zero) value in these column..
try this *Array Formula*
=MIN(IF(A1:A100<>0,A1:A100))
On Wed, Mar 30, 2011 at 3:39 AM, John A. Smith wrote:
> Thank you very much. It works great. One other question please; I
Thank you very much. It works great. One other question please; I have a
column with all formula's and I am looking for the smallest number in it by
using =MIN(range). I get 0 (zero) because the formula is
=IF(DY9="GONE","",D9). DY9 is an automatic status column that shows "GONE"
if a ship date
Hi John,
change the formula to IFERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept
C'!B10),"")
Regards
Umesh
On Tue, Mar 29, 2011 at 8:22 PM, John A. Smith wrote:
> I have like tabs from different departments and need to summarize an
> average score by day. But if there were no scores in a partic
I have like tabs from different departments and need to summarize an average
score by day. But if there were no scores in a particular day, I get
#DIV/0!. Please help with the formula that eliminates it. I tries an
IFERROR in front of the AVERAGE but got a blank cell.
Thank you.
John
--