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
hi there. not sure if i understand. isnt it:
=B1*2
or:
=DAY(G1)*2
or if data not sorted & values could be different, then:
=VLOOKUP(G1,$A$1:$B$30,2,0)+DAY(G1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks