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 filled out in a previous column. D9 is the value of the
shipment yet to ship. =MAX(range) works but it senses the zero if it is
gone so the =MIN(range) doesn't.
Thank you for your kind teaching help.
John
On Tue, Mar 29, 2011 at 4:17 PM, STDEV(i) <setiyowati.d...@gmail.com> wrote:
> Please try, and check if it helps
>
> =IF(COUNT('Dept A:Dept C'!B3)=0,"",AVERAGE('Dept A:Dept C'!B3))
>
> learn 3D Reference more at:
>
> http://office.microsoft.com/en-us/excel-help/create-a-3-d-reference-to-the-same-cell-range-on-multiple-worksheets-HP010102346.aspx
>
>
>
> On Tue, Mar 29, 2011 at 9:52 PM, John A. Smith <johnasmit...@gmail.com>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 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
>>
>>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
