Formual to lookup sumtotal from data with spaces

[Excel Dumbo]

Hello,

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

Thanks

Excel Dumb

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

 

[Kevin@Radstock]

Hi Excel Dumbo

Use IF & ISERROR to trap errors.

Kevin

 

[Ron Rosenfeld]

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 Kevi