Ms Excel Vlookup and SUMIFS Help required
<p>I have a table of 2 clients with history of consumption in the given months with start and end date and count of days as well. I am using V Lookup function to look the client # in the provided table and then count the number of days fall in the Date provided on the other Picture(Work Book 2).</p>

<p>I have that client details in Workbook 1 and the desired days in Workbook 2. But I am not getting the right Answer.</p>

<p>For example as seen in workbook 2 we need to calculate the number of days falls in the summer 2015 and Winter 2016.</p>

<p>I have used dated if(), v lookup and Sum Ifs functions but failed to get the right answer.</p>

<p><a href="https://i.stack.imgur.com/ynmgC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ynmgC.jpg" alt="enter image description here"></a></p>

<p>Please help me.</p>