• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

extracting data from the left using reference from the right of the table

Hi Guys,

please help me with this! I'm trying to add every data on a per date basis but my problem is that the date requires to be at the right column of the data to be extracted. you may refer to the attached file.

thanks in advance!! :) :)
 

Attachments

  • Test.xlsx
    13.2 KB · Views: 0
Hi:

I could not make out what you want here, can you be little bit more specific.

Thanks
 
I get a different answer for 01/01 than you:
upload_2015-5-4_13-49-17.png
I used: =SUMPRODUCT((RIGHT(I$2:I$50,5)=K2)*(H$2:H$50))
and have included the second group of 01/01 which I assume you left out in error

see attached file:
 

Attachments

  • Test.xlsx
    13.4 KB · Views: 0
hi Hui,

thanks for your reply, I just got a little messed up since I was being pushed to finish these on time. but your formula SUMPRODUCT works. I just made some minor edition though, thanks a lot anyway!! :) :)
 
Back
Top