[Excel Dumbo]

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

[Kevin@Radstock]

Hi Excel Dumbo

Use IF & ISERROR to trap errors.

Kevin

Originally Posted by Excel Dumbo

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

[Ron Rosenfeld[_2_]]

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.

[Excel Dumbo]

Thanks Ron and Kevin