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

[Rhon Alvarez]

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!!

 

[Nebu]

Hi:

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

Thanks

 

[Hui]

I get a different answer for 01/01 than you:

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:

 

[Rhon Alvarez]

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!!