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:A1000,A1:A100))
On Wed, Mar 30, 2011 at 3:39 AM, John A. Smith johnasmit...@gmail.comwrote:
Thank you very much. It works great. One
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
--
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 johnasmit...@gmail.comwrote:
I have like tabs from different departments and need to summarize an
average score by day. But if there were no
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 is