| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formual to lookup sumtotal from data with spaces
Hello,
Please refer attached file and advise Formual to lookup sumtotal from data with spaces. Thanks Excel Dumbo |
|
#2
|
|||
|
|||
|
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:
|
|
#3
|
|||
|
|||
|
Thanks Kevin
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spaces at the end of data | Excel Worksheet Functions | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| sumtotal as per date range | Excel Worksheet Functions | |||
| Formual to Lookup and Transpose | Excel Worksheet Functions | |||
| Spaces in Data | Excel Discussion (Misc queries) | |||
Linear Mode
