multiplay sum/vlookup?

Hi, I'm wondering if there is a way to use a sum or vlookup value to what I'd like to do.
I've attached a sample.

I know that sumproduct can be used to return total of multiple lookups in a table. However, my lookup table includes spaces in between the values being looked up, so it messes the formula up.

any help would be hugely appreciated

Thanks

Originally Posted by Azam Ali

Hi Silverscreen

find the attatch file with formula

Hi Azam,

Thanks for help again, it looks good but for cell B3, i only want it to return results from Sheet 2 in column C (matching the dates in the title). i did copy this formula into my sheet using the correct arrays and only selected one column for the value to look for if true. but this didn't seem to work, it returned no numbers

Thanks.