Averageifs returns #DIV/0! - replace with 0?
Just registered and 1st post so apologies if this has been resolved in some hidden thread somewhere..!
I've data that will be pulled in from another source and now excell help = #DIV0.jpgI've created a separate table that gives me the averageif (=AVERAGEIF('Data Look Up Table'!$A$6:A37,"Andover",'Data Look Up Table'!B$6:B37) for each centre, however as I need to list all centre's some have no data therefore returns #DIV/0.
So will return the average of all figures relating to Andover in column B that matches column A in the other sheet.
A) can I only show rows that return a figure
B) or can I 0 the cells that return the error as I would like to average these totals at the bottom of column B
Re: Averageifs returns #DIV/0! - replace with 0?
You can wrap any formula in an IFERROR test to control error results.
Apply that method to your formulas to control the DIV/0 errors.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1