ExcelBanter - Formual to lookup sumtotal from data with spaces

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formual to lookup sumtotal from data with spaces (https://www.excelbanter.com/excel-discussion-misc-queries/448209-formual-lookup-sumtotal-data-spaces.html)

Excel Dumbo

Formual to lookup sumtotal from data with spaces

1 Attachment(s)

Hello,

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

Thanks

Excel Dumbo

Kevin@Radstock

Hi Excel Dumbo

In B2 on the result sheet:

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

Copy across and down.

Kevin

Quote:

Originally Posted by Excel Dumbo (Post 1609483)

Hello,

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

Thanks

Excel Dumbo

Excel Dumbo

Thanks Kevin

All times are GMT +1. The time now is 01:19 PM.