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
Hello,
Please refer attached file and advise Formual to lookup sumtotal from data with spaces.
Thanks
Excel Dumbo
|