kindly refer the attached sheet. I want to look for the value mentioned against the date and add the same for both the columns and mention in column H. eg g1 is 1-Apr-13 so the value of B1 and E30 ie 1+1=2 should be in cell H2.
I know of sumifs or sumproduct will get me what I want but I tried with no result kindly help.
Thanks
Bookmarks