Thank you GoldenLance.
John
On Tue, Mar 29, 2011 at 3:00 PM, GoldenLance <samde...@gmail.com> wrote:
> Try this
>
> =IF(ISERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!
> B10)),"",AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!B10))
>
> On Mar 29, 7: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
> >
> > Calculating An Average from Multiple Tabs Question.xls
> > 42KViewDownload
>
> --
>
> ----------------------------------------------------------------------------------
> 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
