To remove #DIV error
 

Hi ,

Please refer the file stored in the link below and advise the mistake i have made in the formula. I am getting a #DIV error. I would like it to appear as blank. I had trouble attaching this file to this website, hence stored on to a link.

http://speedy.sh/kB4ZD/To-remove-DIV.xls

Thanks

Hi Excel Dumbo

Use IF & ISERROR to trap errors.

Kevin

Formual to lookup sumtotal from data with spaces
 

On Tue, 19 Feb 2013 08:54:34 +0000, Excel Dumbo wrote:


Hello,

Please refer attached file and advise Formual to lookup sumtotal from
data with spaces.

Thanks

Excel Dumbo


+-------------------------------------------------------------------+
|Filename: Formual to lookup sumtotal from data with spaces.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=765|
+-------------------------------------------------------------------+

You'd use the SUMIF function for something like that.

For 2011

Result!B2: =SUMIF('Look UP Data'!$B$1:$B$48,Result!$A2,'Look UP Data'!C$1:C$48)

Fill right to C2, then select B2:C2 and fill down as far as required.

Note that the Range references to columns B and C on Look UP Data can be larger than the data table range, to allow for expansion. They can even refer to the entire column, although that may be inefficient.

Thanks Ron and Kevin