Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi Excel Dumbo
Use IF & ISERROR to trap errors. Kevin Quote:
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
|
|||
|
|||
Thanks Ron and Kevin
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove #N/A Error | Excel Discussion (Misc queries) | |||
error: Excel encountered an error and had to remove some formatting to avoid corrupting the workbook; please recheck your formatting carefully | Excel Programming | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Remove Error | Excel Programming | |||
Remove #DIV/0! error | Excel Discussion (Misc queries) |